1Z0-060 Question #71: Real Exam Question with Answer & Explanation

The correct answer is A: It results in an error because these parameter settings are invalid.. When multiple files are listed in DB_FLASH_CACHE_FILE, an equal number of size values must be provided in DB_FLASH_CACHE_SIZE. Specifying two device files with only one size value is an invalid configuration that prevents startup.

Question

To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = /dev/flash_device_1' , /dev/flash_device_2' DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?

Options

AIt results in an error because these parameter settings are invalid.
BOne 64G flash cache file will be used.
CTwo 64G flash cache files will be used.
DTwo 32G flash cache files will be used.

Explanation

When multiple files are listed in DB_FLASH_CACHE_FILE, an equal number of size values must be provided in DB_FLASH_CACHE_SIZE. Specifying two device files with only one size value is an invalid configuration that prevents startup.

Common mistakes.

B. Oracle does not default to using only the first listed device file when a count mismatch exists; the invalid configuration causes an error, not a fallback to one file.
C. Two flash cache files cannot be initialized because each file requires its own explicit size entry in DB_FLASH_CACHE_SIZE, and only one size is provided.
D. Oracle does not automatically split or divide the single 64G value across multiple device files; each file must have its own corresponding size entry.

Concept tested. Oracle Database Smart Flash Cache parameter count matching

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DB_FLASH_CACHE_SIZE.html

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice