Question: Which of the following is a valid command? a. CREATE INDEX book_profit_idx ON (retail-cost) WHERE (retail-cost) > 10; b. CREATE INDEX book_profit_idx ON (retail-cost); c.

Which of the following is a valid command?
a. CREATE INDEX book_profit_idx

ON (retail-cost) WHERE (retail-cost) > 10;

b. CREATE INDEX book_profit_idx

ON (retail-cost);

c. CREATE FUNCTION INDEX book_profit_idx

ON books WHERE (retail-cost) > 10;

d. Both a and c
e. None of the above

Step by Step Solution

3.39 Rating (177 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

e No... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1212506f_716225.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1212506f_716225.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!