Oracle Database 12c: Multitenancy Essentials — Question 18

Which three are true concerning Smart Scans?

Answer options

• A. The decision to perform a Smart Scan is made by the Optimizer.
• B. Smart Scans are only possible during full table scans or fast full index scans.
• C. Smart Scans are possible on Index Organized Tables (IOTs).
• D. Smart Scans always outperform scans that are not offloaded.
• E. Smart Scans are possible on heap organized tables.
• F. Smart Scans are possible on uncompressed B*Tree indexes.

Correct answer: A, B, F

Explanation

The correct answer is A, B, and F because the Optimizer indeed determines when a Smart Scan should be performed, Smart Scans are limited to full table scans or fast full index scans, and they can be executed on uncompressed B*Tree indexes. Options C, D, and E are incorrect as Smart Scans do not apply to IOTs, do not always outperform other scans, and can be performed on heap organized tables but this does not pertain to the question's criteria.