Oracle
1Z0-083 · Question #58
1Z0-083 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
Oracle Database Architecture
Question
Which two statements are true about indexes and their administration in an Oracle database?
Options
- AAn index can be scanned to satisfy a query without the indexed table being accessed.
- BA non-unique index can be converted to a unique index using a Data Definition Language (DDL)
- CA descending index is a type of bitmapped index.
- DAn invisible index is maintained when a Data Manipulation Language (DML) command is per-
- EAn index is always created by scanning the key columns from the underlying table.
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 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.
Topics
#index-only scans#invisible indexes#DML maintenance#index administration