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

The correct answer is A. A UNIQUE index can be altered to be non-unique 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. See the full explanation below for the reasoning.

Manage Schema Objects

Question

Options

AA UNIQUE index can be altered to be non-unique
BA SELECT statement can access one or more indices without accessing any tables
CA table belonging to one user can have an index that belongs to a different user
DAn update to a table can result in updates to any or all of the table's indexes
EWhen a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are
FAn update to a table can result in no updates to any of the table's indexes

How the community answered

(35 responses)

A
80% (28)
B
11% (4)
C
6% (2)
F
3% (1)

Topics

#indexes#UNIQUE index#RECYCLE BIN#DML index maintenance

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice