Oracle Database 12c: Multitenancy Essentials — Question 27

Which two must be true for a Smart Scan to occur on a table?

Answer options

• A. Sessions querying the table must set cell_offload_processing = true.
• B. It must be stored in an ASM diskgroup with a 4MByte AU size.
• C. It must be heap organized.
• D. It must be accessed using direct path reads.
• E. The table must not be compressed.

Correct answer: A, D

Explanation

For a Smart Scan to be executed, sessions must enable cell_offload_processing, allowing the storage cells to handle the processing. Additionally, accessing the table via direct path reads optimizes the data retrieval process, while the other options do not directly affect the ability to perform a Smart Scan.