Home › Quizzes › Oracle Database Architecture and Administration

Oracle Database Architecture and Administration

Covers Oracle database architecture including memory structures (SGA, buffer cache), physical files (data files, control files, redo logs, parameter files), logical storage (tablespaces, blocks), instance components, and startup/shutdown operations.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In a shared server environment, which of the following areas is located in the SGA and is shared by server process?

  1. SQL work area
  2. Session memory
  3. Process monitor
  4. PFile
  5. Mounting the database
Question 2 Multiple Choice (Single Answer)

Which of the following is the centralized repository where the data is stored?

  1. Oracle database
  2. SQL work area
  3. Oracle database management system
  4. Stream pool
  5. Instance creation
Question 3 Multiple Choice (Single Answer)

Which of the following STARTUP command options is used to open the database for queries only?

  1. READ ONLY
  2. PFILE
  3. FORCE
  4. Instance creation
  5. Stream pool
Question 4 Multiple Choice (Single Answer)

Which of the following SHUTDOWN command options is a case of an improper shutdown?

  1. NORMAL
  2. Immediate
  3. PFILE
  4. Mounting the database
  5. ABORT
Question 5 Multiple Choice (Single Answer)

All objects created in the database by users have their data physically stored in which of the following files?

  1. Password file
  2. Parameter file
  3. Instance creation
  4. Data file
  5. Java pool
Question 6 Multiple Choice (Single Answer)

In which of the following options of SHUTDOWN command will all currently active transactions be allowed to complete?

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

Which of the following options in STARTUP commands is used to perform media recovery, while starting the database?

  1. Flash recovery area
  2. Recovery through resetlogs
  3. RECOVER
  4. FORCE
  5. PFILE
Question 8 Multiple Choice (Single Answer)

Which of the following files keeps a record of the names, size and locations of the different physical files of the database?

  1. Parameter file
  2. Control file
  3. Instance creation
  4. PFILE
  5. SQL work area
Question 9 Multiple Choice (Single Answer)

Which of the following files contains a record of all the changes made in the database?

  1. Parameter file
  2. Password file
  3. Instance creation
  4. Redo log file
  5. SQL work area
Question 10 Multiple Choice (Single Answer)

Which of the following options of STARTUP command is used when you want only users, who possess the privilege to access the database?

  1. FORCE
  2. PFILE
  3. RESTRICT
  4. Password file
  5. Proxy archived log backups
Question 11 Multiple Choice (Single Answer)

Which of the following consists of the memory components of oracle and various background processes?

  1. Oracle instance
  2. Oracle database
  3. Mounting the database
  4. Password file
  5. Parameter file
Question 12 Multiple Choice (Single Answer)

Which of the following files can be used when you use database authentication?

  1. Parameter file
  2. Password file
  3. Instance creation
  4. Data files
  5. Stream pool
Question 13 Multiple Choice (Single Answer)

Which of the following can be reorganized and backed up with minimal impact to other users, whose data may be in other tablespaces?

  1. Segment
  2. Extent
  3. Tablespace
  4. Instance creation
  5. Java pool
Question 14 Multiple Choice (Single Answer)

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

  1. Data dictionary cache
  2. Stream pool
  3. Database buffer cache
  4. SQL work area
  5. Mounting the database
Question 15 Multiple Choice (Single Answer)

Which of the following logical objects is the smallest unit of storage in an oracle database?

  1. Extent
  2. Database block
  3. Schema
  4. Instance creation
  5. Stream pool
← Back to Quizzes