1Z0-536 · Question #2
Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?
The correct answer is A. CELL_FLASH_CACHE attribute on the data object D. Small data less than 128 KBs E. Control file I/Os. A: Preferential treatment over which database objects are cached is also provided with the Exadata Smart Flash Cache. For example, objects can be pinned in the cache and always be cached, or an object can be identified as one which should never be cached. This control is…
Question
Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?
Options
- ACELL_FLASH_CACHE attribute on the data object
- BCACHE hint In the SQL statement
- CData from a table scan
- DSmall data less than 128 KBs
- EControl file I/Os
How the community answered
(34 responses)- A79% (27)
- B12% (4)
- C9% (3)
Explanation
A: Preferential treatment over which database objects are cached is also provided with the Exadata Smart Flash Cache. For example, objects can be pinned in the cache and always be cached, or an object can be identified as one which should never be cached. This control is provided by the new storage clause attribute, CELL_FLASH_CACHE, which can be assigned to a database table, index, partition and LOB column. C: Scans, or sequentially reading tables, generally would not be cached since sequentially accessed data is unlikely to be subsequently followed by reads of the same data.
Topics
Community Discussion
No community discussion yet for this question.