Multiple choice technology databases

A directory name can be a valid value for which of the following parameters?

  1. DB_CACHE_SIZE

  2. DB_FILES

  3. BACKGROUND_DUMP_DEST

  4. DB_BLOCK_SIZE

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

BACKGROUND_DUMP_DEST specifies a directory path where Oracle writes background process trace files and alert logs. Options A (DB_CACHE_SIZE), B (DB_FILES), and D (DB_BLOCK_SIZE) are all numeric parameters - sizes, counts, or block sizes - not directory paths. Only BACKGROUND_DUMP_DEST accepts a directory name as its value.