Which of the following statement(s) is (are) true?
-
a. The CELL_FLASH_CACHE storage clause attribute allows the override of the automatic caching policy, when the compatible parameter is greater than or equal to 11.2.0.0
-
b. The CELL_FLASH_CACHE storage clause attribute can be used to specify how specific database objects are cached in Exadata Smart Flash Cache
-
c. It can have values NONE, DEFAULT and KEEP
-
None of the above
CELL_FLASH_CACHE is a storage clause attribute that controls how database objects are cached in Exadata Smart Flash Cache, overriding the automatic caching policy when compatible parameter is 11.2.0.0 or higher. The attribute accepts three values: NONE (no caching), DEFAULT (uses automatic policy), and KEEP (forces caching). This provides fine-grained control over flash cache usage for specific tables, partitions, or tablespaces.