Which three access paths always generate “cell single b…

An important application has been migrated to a database on an X5 Database Machine.
You are examining high-load SQL statements from this application, in an attempt to determine which ones willbenefit from the Exadata Smart Scan capability.
Which three access paths always generate “cell single block physical read” or “cell multiblock physical read”
requests?

An important application has been migrated to a database on an X5 Database Machine.
You are examining high-load SQL statements from this application, in an attempt to determine which ones willbenefit from the Exadata Smart Scan capability.
Which three access paths always generate “cell single block physical read” or “cell multiblock physical read”
requests?

A.
Index fast full scans executed in parallel

B.
Full table scans on heap organized tables executed in parallel

C.
Full table scans on heap organized tables executed serially

D.
Full table scans on index organized tables executed in parallel

E.
Index unique scan access by primary key to heap organized tables executed in parallel

F.
Index unique scan access by primary key to heap organized tables executed serially

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *