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.
A. There are huge numbers of migrated rows in the table on which the index is being built.
B. There is an uncommitted transaction that has modified one block of the table on which the index is being built, in each cell.
C. There is a transaction that has modified one block of the table on which the index is being built in each cell, which committed after the create index began.
D. There are huge numbers of chained rows in the table on which the index is being built.
E. There is a ROWID column in the table on which the index is being built.
|
Download Printable PDF. VALID exam to help you PASS. |
 |