Oracle
1Z0-027 · Question #6
1Z0-027 Question #6: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-027 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.
Question
You are evaluating the performance of a SQL statement that accesses a very large table, and have run the following query producing the output shown: For which two reasons would the; "physical read total bytes" statistic be greater than the "cell physical IO bytes eligible for predicate offload" statistic?
Exhibit
Options
- AThere is an index on the column used in the where clause, causing "cell multiblock physical reads"
- BThe table is an IOT and has an overflow segment, causing "cell multiblock physical reads" to be
- CThere is an uncommitted transaction that has modified some of the table blocks, causing some "cell
- DThe table is an indexed clustered table, causing "cell single block physical reads" to be requested
- EThere are migrated rows in the table, causing some "cell single block physical reads" to be requested
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.