Oracle
1Z0-047 · Question #228
1Z0-047 Question #228: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #228. The question stem and answer options stay visible for context.
Question
Which statements are correct regarding indexes? (Choose all that apply.)
Options
- AWhen a table is dropped, the corresponding indexes are automatically dropped.
- BFor each DML operation performed, the corresponding indexes are automatically updated.
- CIndexes should be created on columns that are frequently referenced as part of an expression.
- DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.