Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 41 of 57

Marks: +1, -0

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

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

Go to Question:

Prev Question

Next Question