Home › Quizzes › Oracle Database Architecture and Fundamentals

Oracle Database Architecture and Fundamentals

Covers Oracle Database architecture including memory structures (SGA, PGA), background processes, logical and physical storage, and RMAN backup fundamentals.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is a centralised container where the data is stored?

  1. Read only
  2. Extent
  3. Oracle instance
  4. Instance creation
  5. Oracle database
Question 2 Multiple Choice (Single Answer)

The contents of which memory components of the system global area are shared by multiple users?

  1. Instance creation
  2. Stream pool
  3. SQL work area
  4. Shared pool
  5. Force
Question 3 Multiple Choice (Single Answer)

Which of the following memory components of the program global area holds a session's variables and session-related information?

  1. Stream pool
  2. ABORT
  3. Session memory
  4. SQL work area
  5. Instance creation
Question 4 Multiple Choice (Single Answer)

Which of the following memory components of the system global area is used for handling large input/output requests of server processes?

  1. Instance creation
  2. Large pool
  3. SQL work area
  4. Stream pool
  5. Read only
Question 5 Multiple Choice (Single Answer)

During which of the following phases of 2-phase locking mechanism, locks are only released?

  1. Compilation phase
  2. Shrinking phase
  3. Growing phase
  4. Two-very-phase
  5. Local agent
Question 6 Multiple Choice (Single Answer)

Which of the following features of the RMAN describes the contents of the backup sets that define which files are multiplexed?

  1. Proxy archived log backups
  2. Oracle flashback database
  3. Duplicate database
  4. Stream pool
  5. Disk topology and automatic performance tuning
Question 7 Multiple Choice (Single Answer)

Which of the following background processes writes modified blocks from the database buffer cache to the data files?

  1. Oracle server
  2. Log writer
  3. Job queue process
  4. Database writer
  5. Mounting the database
Question 8 Multiple Choice (Single Answer)

Which of the following is a set of extents allocated for a certain logical structure such as a table?

  1. Duplicate database
  2. Segment
  3. Database block
  4. PFILE
  5. Views
Question 9 Multiple Choice (Single Answer)

The data of logical database structures such as tables and indexes is physically stored in the __________ files allocated for a database.

  1. read only
  2. archive
  3. data
  4. parameter
  5. instance creation
Question 10 Multiple Choice (Single Answer)

Which of the following background processes writes modified blocks from the database buffer cache to the datafiles?

  1. Oracle server
  2. Log writer
  3. Job queue process
  4. Database writer
  5. Mounting the database
Question 11 Multiple Choice (Single Answer)

Which of the following interfaces is an alternative method for issuing commands to RMAN and receiving the output from those commands?

  1. Media management application
  2. Member method
  3. Command file
  4. RMAN pipe interface
  5. Two-very-safe
Question 12 Multiple Choice (Single Answer)

During which of the following phases, RMAN sends the remote procedure calls to the target database and remotes their progress?

  1. Image copy
  2. Growing phase
  3. Compilation phase
  4. Execution phase
  5. Two-very-safe
Question 13 Multiple Choice (Single Answer)

Which of the following logical storage structures usually facilitates security, performance or the availability of database objects such as tables and indexes?

  1. Mounting the database
  2. Extent
  3. Oracle instance
  4. Archive files
  5. Tablespace
Question 14 Multiple Choice (Single Answer)

Which of the following RAID levels refers to mirrored set without parity?

  1. Registration
  2. RAID level 5
  3. RAID level 6
  4. Duplicate database
  5. RAID level 1
Question 15 Multiple Choice (Single Answer)

Which of the following classifications of the degree of durability has the problem that updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing?

  1. Exclusive mode
  2. Two-very-safe
  3. Growing phase
  4. One-safe
  5. Detection of failure
← Back to Quizzes