Oracle Database Administration I — Question 40

Which three statements are true regarding indexes? (Choose three.)

Answer options

• A. A UNIQUE index can be altered to be non-unique
• B. A SELECT statement can access one or more indices without accessing any tables
• C. A table belonging to one user can have an index that belongs to a different user
• D. An update to a table can result in updates to any or all of the table's indexes
• E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• F. An update to a table can result in no updates to any of the table's indexes

Correct answer: B, D, F

Explanation

Option B is correct because a SELECT statement can indeed access indexes directly without needing to reference the underlying table data. Option D is also correct as any update to a table can necessitate updates to its indexes to maintain their accuracy. Option F is valid as well, since it is possible for a table's modification to occur without affecting its indexes, depending on the nature of the change. The other options contain inaccuracies regarding how indexes function and their relationships with tables.