Oracle Exam 1Z0-060 Topic 2 Question 30 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 30
Topic #: 2

On your Oracle 12c database, you issue the following commands to create indexes:

SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id);

SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);

Which statement is correct?

AOnly the ORD_CUSTOMER_IX1 index is created and it is visible.

BBoth the indexes are created and both of them are visible.

CBoth the indexes are created; however, only the ORD_CUSTOMER_IX1 index is visible.

DBoth the indexes are created; however, only the ORD_CUSTOMER_IX2 index is visible.

Show Suggested Answer

Suggested Answer: D

by Ezekiel at May 07, 2022, 06:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!