Which of the following parameters can be used in the file DB_CONFIG? (Select TWO correct answers.)

Question

Options

• Aset_cachesize
• Bset_cachepath
• Cset_db_type
• Dset_db_path
• Eset_lg_max

• A
  91% (20)
• B
  5% (1)
• D
  5% (1)

Explanation

set_cachesize (A) and set_lg_max (E) are both legitimate Berkeley DB environment configuration parameters recognized in the DB_CONFIG file. set_cachesize controls the size of the shared memory buffer pool (cache), and set_lg_max sets the maximum size of a single transaction log file - both are environment-level settings that belong in DB_CONFIG.

Why the distractors are wrong:

• B (set_cachepath) - Not a valid parameter; there is no such directive. Cache configuration is handled via set_cachesize, not a path setting.
• C (set_db_type) - Database type is set programmatically via DB->set_type() in code, not through DB_CONFIG.
• D (set_db_path) - Not a valid directive; the data directory is configured with set_data_dir, not set_db_path.

Memory tip: Focus on the prefixes - set_cachesize (cache/memory) and set_lg_* (log management) are environment-level concerns that belong in DB_CONFIG. Any parameter with a db_ prefix in these choices is a trap - database-specific settings are handled in application code, not the environment config file.

No community discussion yet for this question.