Oracle Exam 1Z0-070 Topic 9 Question 25 Discussion

Actual exam question for Oracle's 1Z0-070 exam

Question #: 25
Topic #: 9

You are evaluating the performance of a SQL statement that accesses a very large table.

You run this query:

Identify two reasons why the ''physical read total bytes'' statistic is greater than the ''cell physical IO bytes eligible for predicate offload'' statistic.

AThere is an index on the column used in the WHERE clause, causing ''cell multiblock physical reads'' to be requested by the database instance, resulting in additional I/O.

BThe table is an IOT and has an overflow segment, causing ''cell multiblock physical reads'' to be requested by the database instance, resulting in additional I/O.

CThere is an uncommitted transaction that has modified some of the table blocks, causing some ''cell single block physical reads'' to be requested by the database instance, resulting in additional I/O.

DThe table is an index clustered table, causing ''cell single block physical reads'' to be requested by the database instance, resulting in additional I/O.

EThere are migrated rows in the table, causing some ''cell single block physical reads'' to be requested by the database instance, resulting in additional I/O.

Show Suggested Answer

Suggested Answer: A, C, F

by Abel at May 06, 2022, 06:54 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-070 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!