Oracle
1Z0-027 · Question #23
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…
The correct answer is C. Full table scans on heap tables executed in parallel F. fast full scans on B*Tree indexes executed in parallel. See the full explanation below for the reasoning.
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
How the community answered
(31 responses)- A3% (1)
- B3% (1)
- C74% (23)
- D13% (4)
- G6% (2)
Community Discussion
No community discussion yet for this question.