Oracle
1Z0-071 · Question #361
Which three statements are true regarding indexes? (Choose three.)
The correct answer is A. A SELECT statement can access one or more indices without accessing any tables B. An update to a table can result in no updates to any of the table's indexes F. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are. See the full explanation below for the reasoning.
Question
Which three statements are true regarding indexes? (Choose three.)
Options
- AA SELECT statement can access one or more indices without accessing any tables
- BAn update to a table can result in no updates to any of the table's indexes
- CA table belonging to one user can have an index that belongs to a different user
- DA UNIQUE index can be altered to be non-unique
- EAn update to a table can result in updates to any or all of the table's indexes
- FWhen a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are
How the community answered
(27 responses)- A81% (22)
- C4% (1)
- D4% (1)
- E11% (3)
Community Discussion
No community discussion yet for this question.