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 will benefit 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

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.