Oracle
1Z0-071 · Question #333
1Z0-071 Question #333: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #333. The question stem and answer options stay visible for context.
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
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.