Oracle
1Z0-071 · Question #333
Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
The correct answer is A. An index can be created as part of a CREATE TABLE statement. D. A descending index is a type of function-based index. F. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on. See the full explanation below for the reasoning.
Question
Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
Options
- AAn index can be created as part of a CREATE TABLE statement.
- BA DROP INDEX statement always prevents updates to the table during the drop operation.
- CA unique and non-unique index can be created on the same table column.
- DA descending index is a type of function-based index.
- EIf a query filters on an indexed column then it will always be used during execution of the query.
- FAn INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on
How the community answered
(41 responses)- A76% (31)
- B15% (6)
- C5% (2)
- E5% (2)
Community Discussion
No community discussion yet for this question.