Which two are true about Smart Scan?
A.
A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart
Scan.
B.
Column projection does not contribute to the performance benefit of Smart Scan.
C.
A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
D.
It is possible to offload single row functions to the Exadata Storage Servers.
E.
Join processing can be partly offloaded to Exadata Storage Servers.
F.
Join processing can be fully offloaded to Exadata Storage Servers.
Explanation:
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References: http://www.centroid.com/blog/exadata-smart-scan-processing