Oracle Database 12c: Multitenancy Essentials — Question 7

Which three are true concerning Exadata Smart Flash Cache on X6 Database Machines with High Capacity Storage Servers?

Answer options

• A. The "keep" cache is limited to a maximum of 80% of the total Smart Flash Cache capacity.
• B. Smart Scan will always use the Smart Flash Cache for all I/Os fast full index capacity.
• C. Smart Scan will always use the Smart Flash Cache for all I/Os for full table scans.
• D. Single block reads can benefit from Smart Flash Cache.
• E. Multiblock reads can benefit from Smart Flash Cache.

Correct answer: B, D, E

Explanation

The correct answers are B, D, and E because Smart Scan indeed leverages Smart Flash Cache for fast access to index data, and both single and multiblock reads benefit from the cache for improved performance. Option A is incorrect as it misrepresents the caching limits, and option C is also wrong because Smart Scan does not always use the cache for full table scans.