Oracle
1Z0-071 · Question #436
Which two statements are true regarding indexes? (Choose two.)
The correct answer is B. An update to a table can result in no updates to any of the table's indexes. E. A table belonging to one user cannot have an index that belongs to a different user. See the full explanation below for the reasoning.
Question
Which two statements are true regarding indexes? (Choose two.)
Options
- AAn update to a table can result in updates to any or all of the table's indexes.
- BAn update to a table can result in no updates to any of the table's indexes.
- CA UNIQUE index can be altered to be non-unique.
- DWhen a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are
- EA table belonging to one user cannot have an index that belongs to a different user.
How the community answered
(49 responses)- A12% (6)
- B82% (40)
- C2% (1)
- D4% (2)
Community Discussion
No community discussion yet for this question.