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

Question : 25 of 57

Marks: +1, -0

Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)

An index can be created as part of a CREATE TABLE statement.
A DROP INDEX statement always prevents updates to the table during the drop operation.
A unique and non-unique index can be created on the same table column.
A descending index is a type of function-based index.
If a query filters on an indexed column then it will always be used during execution of the query.
An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table

Go to Question:

Prev Question

Next Question