Which three statements are true regarding indexes? (Choose three.)
A. A SELECT statement can access one or more indices without accessing any tables
B. An update to a table can result in no updates to any of the table’s indexes
C. A table belonging to one user can have an index that belongs to a different user
D. A UNIQUE index can be altered to be non-unique
E. An update to a table can result in updates to any or all of the table’s indexes
F. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
|
Download Printable PDF. VALID exam to help you PASS. |
 |
ABC
BCE
In my humble opinion: ABE
A. A SELECT statement can access one or more indices without accessing any tables. (TRUE)- SELECT can access indices via DATA Dictionary, for example
B. An update to a table can result in no updates to any of the table’s indexes. (TRUE)
C. A table belonging to one user can have an index that belongs to a different user. (FALSE). A table belonging t one user CANNOT have an index that belongs to another user.
D. A UNIQUE index can be altered to be non-unique (FALSE) However, UNIQUE and NON-UNIQUE indexes (not constraints) can be created on the same column (one visible, the other invisible)
E. An update to a table can result in updates to any or all of the table’s indexes. (TRUE)
F. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped. (FALSE) FLASHBACK can recover indexes until PURGE.
BDE
bce
AEF
ACE
CEF
ABC imho
ABF
BCD