Oracle Database SQL — Question 239

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

Answer options

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

Correct answer: A, B

Explanation

Answer A is correct because updates to a table necessitate changes to its associated indexes to maintain data integrity. Answer B is also correct as certain updates may not affect any indexes, particularly if the indexed columns are not modified. The other options are incorrect because a UNIQUE index cannot be altered to be non-unique (C), indexes are not permanently dropped when a table is moved to the RECYCLE BIN (D), and indexes can be created by different users on the same table (E).