Home › Quizzes › RDBMS

RDBMS

This test is useful for the students who are preparing for GATE, information technology and IT certified program related exams.This test represents relational database design, architecture etc....

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following background processes is used to resolve distributed transactions that are pending due to a network failure or system failure in a distributed database?

  1. Log writer
  2. Recoverer
  3. Lock manager server
  4. Queue monitor
  5. Mounting the database
Question 2 Multiple Choice (Single Answer)

Which of the following logical storage structures are the logical structures that directly refer to the database's data?

  1. Schema
  2. Table
  3. Extent
  4. Segment
  5. Instance creation
Question 3 Multiple Choice (Single Answer)

Which of the following memory components of the SGA contains 'dirty' or modified blocks and clean or unused blocks?

  1. The stream pool
  2. The java pool
  3. Database buffer cache
  4. Session memory
  5. Read only
Question 4 Multiple Choice (Single Answer)

Which of the following files can have certain characteristic set to let them automatically extend when the database runs out of space?

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

Which of the following memory components of the SGA is a circular buffer that contains redo entries, which reflect changes made to the database?

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

Which of the following background processes is designed to perform batched writes with high efficiency?

  1. Database writer
  2. Queue monitor
  3. Log writer
  4. Lock manager server
  5. Mounting the database
Question 7 Multiple Choice (Single Answer)

In which of the following logical storage structures dooes the disk access time improve because related rows are physically stored together?

  1. Segment
  2. Cluster
  3. Table
  4. Extent
  5. Abort
Question 8 Multiple Choice (Single Answer)

The primary function of which of the following files is to record all changes made to data?

  1. The password file
  2. The parameter file
  3. Redo log file
  4. Instance creation
  5. Recover
Question 9 Multiple Choice (Single Answer)

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

  1. Session memory
  2. Read only
  3. The java pool
  4. SQL work area
  5. The stream pool
Question 10 Multiple Choice (Single Answer)

Which of the following background processes cleans up temporary segments that are no longer in use?

  1. Mounting the database
  2. Lock manager server
  3. System monitor
  4. Log writer
  5. Queue monitor
Question 11 Multiple Choice (Single Answer)

Which of the following memory components of the SGA provides large memory allocations for Oracle backup and restore operations, I/O server processes, etc.?

  1. The stream pool
  2. The Java pool
  3. Large pool
  4. Session memory
  5. Opening the database
Question 12 Multiple Choice (Single Answer)

Which of the following logical storage structures can also be considered a stored query?

  1. View
  2. Table
  3. Segment
  4. Extent
  5. Abort
Question 13 Multiple Choice (Single Answer)

The entries such as tablespace names, checkpoint information, as and when checkpoints are made, etc., are maintained in which of the following files?

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

Which of the following background processes checks on dispatcher and server process and restart them if they have failed?

  1. Process monitor
  2. Mounting the database
  3. Queue monitor
  4. Log writer
  5. Lock manager server
Question 15 Multiple Choice (Single Answer)

In a shared server enviornment, which of the following memory components of the PGA is located in the system global area?

  1. Session memory
  2. Private SQL area
  3. Recover
  4. The stream pool
  5. The java pool
← Back to Quizzes