Home › Quizzes › Oracle Database Architecture and Design

Oracle Database Architecture and Design

Oracle database architecture fundamentals including memory structures (SGA and PGA), background processes, logical storage structures, database operations, and recovery mechanisms.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Names and locations of data files and online redo log files entries are maintained in which of the following files?

  1. The parameter file
  2. The archive files
  3. Instance creation
  4. NORMAL
  5. Control file
Question 2 Multiple Choice (Single Answer)

Which of the following background processes writes redo log entries to disk?

  1. Database writer
  2. System monitor
  3. Log writer
  4. Archiever
  5. READ ONLY
Question 3 Multiple Choice (Single Answer)

At specific times, all modified database buffers in the SGA are written to the datafiles by database writer. This event is called _______.

  1. database writer
  2. checkpoint
  3. system monitor
  4. conflicts
  5. opening the database
Question 4 Multiple Choice (Single Answer)

Which of the following logical storage structures corresponds to a specific number of bytes of physical database space on disk?

  1. Tablespace
  2. Oracle datablock
  3. Segment
  4. Instance creation
  5. FORCE
Question 5 Multiple Choice (Single Answer)

Each session that issues a SQL statement has which of the following memory components of the Program global area?

  1. The java pool
  2. Opening the database
  3. The stream pool
  4. Session memory
  5. Private SQL area
Question 6 Multiple Choice (Single Answer)

The contents of the which of the following memory components of the SGA, are transferred periodically from memory to the online redo log files on disk by the log writer background process?

  1. Redo log buffer
  2. The stream pool
  3. The java pool
  4. Session memory
  5. Mounting the database
Question 7 Multiple Choice (Single Answer)

Which of the following logical storage structures is a specific number of contiguous data blocks obtained in a single allocation, used to store a specific type of information?

  1. Segment
  2. Tablespace
  3. Extent
  4. Instance creation
  5. READ ONLY
Question 8 Multiple Choice (Single Answer)

Which of the following memory components of the SGA prevents SQL statements from being repeatedly parsed thus improving performance during execution of SQL statements?

  1. The stream pool
  2. Library cache
  3. Session memory
  4. The java pool
  5. The archive files
Question 9 Multiple Choice (Single Answer)

In which of the following memory components of the SGA, blocks that need to be modified, are modified in memory and are written back to disk periodically?

  1. Mounting the database
  2. Session Memory
  3. The stream pool
  4. The database buffer cache
  5. The java pool
Question 10 Multiple Choice (Single Answer)

In which of the following modes of SHUTDOWN command, after the transactions have been rolled back the user sessions are terminated?

  1. IMMEDIATE
  2. NORMAL
  3. FORCE
  4. RECOVER
  5. Mounting the database
Question 11 Multiple Choice (Single Answer)

The information in which of the following logical storage structures is used during database recovery to rollback uncommitted transactions for user?

  1. Rollback segment
  2. Data segment
  3. Tablespace
  4. Instance creation
  5. RECOVER
Question 12 Multiple Choice (Single Answer)

In which of the following option of the SHUTDOWN command, all user connection are abnormally terminated?

  1. NORMAL
  2. FORCE
  3. ABORT
  4. TRANSACTIONAL
  5. The password file
Question 13 Multiple Choice (Single Answer)

Which of the following background processes monitor the message queues for oracle advanced queuing?

  1. Job queue process
  2. Queue monitor
  3. System monitor
  4. Database writer
  5. Proxy archived log backup
Question 14 Multiple Choice (Single Answer)

Which of the following memory components of the PGA is used for operations such as hash-joins, bitmap create operations, etc?

  1. Session memory
  2. Opening the database
  3. The java pool
  4. SQL work area
  5. The stream pool
Question 15 Multiple Choice (Single Answer)

Which of the following logical storage structures are customized presentation of data in one or more tables?

  1. Segment
  2. Views
  3. Tablespace
  4. Instance creation
  5. READ ONLY
← Back to Quizzes