1Z0-060 · Question #135
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…
The correct answer is A. Both the indexes are created; however, only the ORD_COSTOMER index is visible. E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table. 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…
Question
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 statement are correct?
Options
- ABoth the indexes are created; however, only the ORD_COSTOMER index is visible.
- BThe optimizer evaluates index access from both the Indexes before deciding on which index to use for
- COnly the ORD_CUSTOMER_IX1 index is created.
- DOnly the ORD_CUSTOMER_IX2 index is created.
- EBoth the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
How the community answered
(51 responses)- A75% (38)
- B8% (4)
- C4% (2)
- D14% (7)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.