Exam 1z0-062 topic 1 question 147 discussion

Actual exam question from Oracle's 1z0-062

Question #: 147
Topic #: 1

On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statements are correct? (Choose two.)

A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
C. Only the ORD_CUSTOMER_IX1 index is created.
D. Only the ORD_CUSTOMER_IX2 index is created.
E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

Show Suggested Answer

Suggested Answer: AE 🗳️
11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.

by khan at April 14, 2019, 4:21 p.m.

Comments

Submit Cancel

khan

Highly Voted 6 years, 2 months ago

The answer is right: A E. However, the wording of option A should be: “Both the indexes are created; however, only the ORD_COSTOMER_IX2 index is visible.”

upvoted 9 times

jackymak

3 years, 4 months ago

Invisible index will be considered for optimizer

upvoted 1 times

jackymak

3 years, 3 months ago

I mean will NOT be

upvoted 1 times

...

5kong

Most Recent 5 years, 3 months ago

Question #118

upvoted 2 times

...