Oracle Database Administration I — Question 106

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

Answer options

• A. A non-unique index can be altered to be unique.
• B. An update to a table can result in no updates to any of the table's indexes.
• C. The RECYCLE BIN never contains indexes.
• D. An update to a table can result in updates to any or all of the table's indexes.
• E. A table belonging to one user cannot have an index that belongs to a different user.

Correct answer: B, D

Explanation

Option B is correct because an update to a table does not always require changes to the indexes, especially if the updated data does not affect indexed columns. Option D is also correct, as updates might necessitate changes to the indexes to maintain data integrity. The other options are incorrect; for instance, option A is misleading as non-unique indexes typically cannot be directly altered to become unique without recreating them, and option C is false because indexes can sometimes be found in the RECYCLE BIN depending on the database system.