Oracle
1Z0-027 · Question #72
1Z0-027 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-027 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
You are monitoring and evaluating a create index statement on your Database Machine and have run the following query after executing statement, providing the output. Shown: Select two reasons why the statement would have produced so many "cell single block physical read" waits compared to "cell smart table scan" waits.
Exhibit
Options
- AThere are huge numbers of migrated rows in the table on which the index is being built.
- BThere is an uncommitted transaction that has modified one block of the table on which the index is being
- CThere is a transaction that has modified one block of the table on which the index is being built in each cell,
- DThere are huge numbers of chained rows in the table on which the index is being built.
- EThere is a ROWID column in the table on which the index is being built.
Unlock 1Z0-027 to see the answer
You've previewed enough free 1Z0-027 questions. Unlock 1Z0-027 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.