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.

ABF

B: In order for queries to take advantage of Exadatas Offloading capabilities, the optimizer must decide to execute a statement with a Full Table Scan or a Fast Full Index Scan. F: Smart Scans can be used for full scanning through B*Tree index segments. References: Expert Oracle Exadata - K. Osborne, et al., (Apress, 2011) BBS, page 346