DB Creation   «Prev  Next»

Preparing to create an Oracle Database - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which initialization parameter fixes the standard database block size at database creation and must not be changed afterward?
Select the best answer.
  A. COMPATIBLE
  B. DB_BLOCK_SIZE
  C. CONTROL_FILES
  D. DB_FILES

2. Which workload may benefit from larger database blocks, subject to performance testing?
Select the best answer.
  A. A scan-intensive decision-support or data-warehouse workload
  B. A workload that only performs small random single-row lookups
  C. Every workload, regardless of its access pattern
  D. Any application solely because its name includes artificial intelligence

3. With heavy redo generation, too few or undersized online redo log groups can contribute to which two log-switch waits?
Select all correct answers.
  A. Waiting because the checkpoint needed to reuse the next group is incomplete.
  B. Waiting because every transaction must fit in one redo log file.
  C. Waiting because required archiving of the next group is incomplete.
  D. Waiting because all members of a redo log group must contain different redo.

4. Why must SGA sizing account for the total memory available to the database host?
Select the best answer.
  A. The database buffer cache is outside the SGA and always needs an equal-sized allocation.
  B. An oversized SGA overwrites SQL plans by overflowing into the shared pool.
  C. Oracle must fill every buffer before it can process any SQL.
  D. An excessive allocation can leave too little memory for the PGA, operating system, and other workloads.

5. Oracle specifies that DB_BLOCK_SIZE must be a multiple of which underlying value?
Select the best answer.
  A. The largest row size in the database
  B. The physical block size at the device level
  C. The control file size
  D. The CPU word size