Oracle
1Z0-062 · Question #99
1Z0-062 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
Question
On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?
Options
- AOnly the ORD_CUSTOMER_IX1 index created.
- BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
- CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for
- DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the
- EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.
- FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.