Which three statements are true about indexes and their administration in an Oracle database?
A. An index can be created as part of a CREATE TABLE statement.
B. A DROP INDEX statement always prevents updates to the table during the drop operation.
C. A UNIQUE and non-unique index can be created on the same table column.
D. A descending index is a type of function-based index.
E. If a query filters on an indexed column then it will always be used during execution of the query.
F. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
ACD
acd
ACD