Oracle
1Z0-027 · Question #23
1Z0-027 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-027 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
A read-only application is in development and is using a test database on a Database Machine. You are examining SQL statements from this application in an attempt to determine which ones will benefit from the Exadata Smart scan capability. The following is true about the tables used by the application: 1. The data for the tables has just been loaded. 2. There are no applications accessing the tables currently. 3. None of the indexes are compressed or reverse key indexes. 4. The tables use the default organization type data. 5. The only data types for the table are varchar (2), number, or date. 6. The largest number of columns for any table is 29. 7. No access is based on ROWID, or virtual columns. Which two access paths will always generate either a set of "cell smart table scan" or a set of "cell smart index scan" requested?
Options
- AFull scans on sorted hash clustered tables executed in parallel
- BFull table scans on index organized tables executed in parallel.
- CFull table scans on heap tables executed in parallel
- DFull scans on index clustered tables executed in parallel
- Efull scans on hash clustered tables executed in serially
- Ffast full scans on B*Tree indexes executed in parallel
- Gfull index scans on B*Tree indexes executed in parallel
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.