1. Which Oracle component consists of memory structures and background processes that enable
database access?
A) Oracle database
B) Oracle instance
C) Tablespace
D) Datafile
Correct Answer: B) Oracle instance
An Oracle instance combines System Global Area (SGA) memory, Program Global Area (PGA)
memory, and background processes to provide database access functionality.
2. What is the primary difference between an Oracle instance and an Oracle database?
A) Instance contains datafiles while database contains memory
B) Instance is memory and processes while database is physical files
C) Instance stores redo logs while database stores control files
D) Instance manages users while database manages tablespaces
Correct Answer: B) Instance is memory and processes while database is physical files
The instance represents the memory structures and background processes that access the database,
while the database consists of physical files like datafiles, control files, and redo logs.
3. Which physical file stores the actual user data within an Oracle database?
A) Control file
B) Redo log
C) Datafile
D) Parameter file
Correct Answer: C) Datafile
Datafiles are physical files on disk that store actual database data for their associated tablespace,
containing tables, indexes, and other database objects.
4. What is the purpose of a tablespace in an Oracle database?
A) To store control file information
B) To provide logical storage grouping for datafiles
C) To manage user sessions
D) To store redo log entries
,Correct Answer: B) To provide logical storage grouping for datafiles
A tablespace serves as a logical storage unit that contains one or more datafiles, providing
organization and management of physical database storage.
5. Which Oracle component stores a record of all changes made to the database for recovery
purposes?
A) Control file
B) Datafile
C) Redo log
D) Tablespace
Correct Answer: C) Redo log
Redo log files maintain a chronological record of all changes made to database data, essential for
recovery operations and transaction rollback.
6. What critical file contains metadata about database structure and is required for database
startup?
A) Datafile
B) Redo log
C) Control file
D) Parameter file
Correct Answer: C) Control file
The control file stores crucial database metadata including database name, datafile locations, redo
log information, and checkpoint data needed to start the database.
7. Which memory structure is shared among all database sessions in an Oracle instance?
A) PGA
B) SGA
C) UGA
D) CGA
Correct Answer: B) SGA
The System Global Area (SGA) is a shared memory region that contains data and control information
for all server processes and background processes in the instance.
8. What type of memory area is private to each server process in Oracle?
A) SGA
B) Shared Pool
C) PGA
,D) Buffer Cache
Correct Answer: C) PGA
The Program Global Area (PGA) is private memory allocated for each server process containing
session-specific information and sort operations.
9. Which SGA component stores SQL and PL/SQL code for reuse across sessions?
A) Buffer Cache
B) Redo Log Buffer
C) Shared Pool
D) Large Pool
Correct Answer: C) Shared Pool
The Shared Pool caches SQL statements, PL/SQL code, and execution plans for reuse, improving
performance by reducing parsing operations.
10. What is the function of the Buffer Cache in the SGA?
A) Store redo entries temporarily
B) Cache recently accessed data blocks
C) Store SQL parse trees
D) Manage sort operations
Correct Answer: B) Cache recently accessed data blocks
The Buffer Cache stores copies of data blocks from datafiles, reducing physical I/O by providing fast
access to frequently queried data.
11. Where does Oracle temporarily hold redo data before writing to redo log files?
A) Buffer Cache
B) Shared Pool
C) Redo Log Buffer
D) Large Pool
Correct Answer: C) Redo Log Buffer
The Redo Log Buffer is a memory area that temporarily stores redo entries until they are written to
online redo log files by the LGWR process.
12. Which optional SGA area is primarily used for backup operations and parallel queries?
A) Java Pool
B) Streams Pool
C) Shared Pool
D) Large Pool
, Correct Answer: D) Large Pool
The Large Pool is an optional memory area that provides memory for large I/O operations, backup
operations, and parallel query execution.
13. Which background process writes dirty data blocks from the buffer cache to datafiles?
A) LGWR
B) CKPT
C) DBWn
D) SMON
Correct Answer: C) DBWn
The Database Writer (DBWn) process writes modified data blocks from the buffer cache to datafiles
when the buffer cache becomes full or checkpoints occur.
14. What background process writes redo log buffer contents to online redo log files?
A) DBWn
B) CKPT
C) LGWR
D) SMON
Correct Answer: C) LGWR
The Log Writer (LGWR) process writes redo entries from the redo log buffer to online redo log files
during commit operations and when buffer is full.
15. Which process signals DBWn to write data and updates file headers during checkpoint
operations?
A) LGWR
B) CKPT
C) SMON
D) PMON
Correct Answer: B) CKPT
The Checkpoint process (CKPT) updates control files and datafile headers with checkpoint information
and signals DBWn to write dirty buffers.
16. What is the primary responsibility of the SMON background process?
A) Clean up failed user sessions
B) Perform instance recovery during startup
C) Write redo log entries
D) Archive redo logs
database access?
A) Oracle database
B) Oracle instance
C) Tablespace
D) Datafile
Correct Answer: B) Oracle instance
An Oracle instance combines System Global Area (SGA) memory, Program Global Area (PGA)
memory, and background processes to provide database access functionality.
2. What is the primary difference between an Oracle instance and an Oracle database?
A) Instance contains datafiles while database contains memory
B) Instance is memory and processes while database is physical files
C) Instance stores redo logs while database stores control files
D) Instance manages users while database manages tablespaces
Correct Answer: B) Instance is memory and processes while database is physical files
The instance represents the memory structures and background processes that access the database,
while the database consists of physical files like datafiles, control files, and redo logs.
3. Which physical file stores the actual user data within an Oracle database?
A) Control file
B) Redo log
C) Datafile
D) Parameter file
Correct Answer: C) Datafile
Datafiles are physical files on disk that store actual database data for their associated tablespace,
containing tables, indexes, and other database objects.
4. What is the purpose of a tablespace in an Oracle database?
A) To store control file information
B) To provide logical storage grouping for datafiles
C) To manage user sessions
D) To store redo log entries
,Correct Answer: B) To provide logical storage grouping for datafiles
A tablespace serves as a logical storage unit that contains one or more datafiles, providing
organization and management of physical database storage.
5. Which Oracle component stores a record of all changes made to the database for recovery
purposes?
A) Control file
B) Datafile
C) Redo log
D) Tablespace
Correct Answer: C) Redo log
Redo log files maintain a chronological record of all changes made to database data, essential for
recovery operations and transaction rollback.
6. What critical file contains metadata about database structure and is required for database
startup?
A) Datafile
B) Redo log
C) Control file
D) Parameter file
Correct Answer: C) Control file
The control file stores crucial database metadata including database name, datafile locations, redo
log information, and checkpoint data needed to start the database.
7. Which memory structure is shared among all database sessions in an Oracle instance?
A) PGA
B) SGA
C) UGA
D) CGA
Correct Answer: B) SGA
The System Global Area (SGA) is a shared memory region that contains data and control information
for all server processes and background processes in the instance.
8. What type of memory area is private to each server process in Oracle?
A) SGA
B) Shared Pool
C) PGA
,D) Buffer Cache
Correct Answer: C) PGA
The Program Global Area (PGA) is private memory allocated for each server process containing
session-specific information and sort operations.
9. Which SGA component stores SQL and PL/SQL code for reuse across sessions?
A) Buffer Cache
B) Redo Log Buffer
C) Shared Pool
D) Large Pool
Correct Answer: C) Shared Pool
The Shared Pool caches SQL statements, PL/SQL code, and execution plans for reuse, improving
performance by reducing parsing operations.
10. What is the function of the Buffer Cache in the SGA?
A) Store redo entries temporarily
B) Cache recently accessed data blocks
C) Store SQL parse trees
D) Manage sort operations
Correct Answer: B) Cache recently accessed data blocks
The Buffer Cache stores copies of data blocks from datafiles, reducing physical I/O by providing fast
access to frequently queried data.
11. Where does Oracle temporarily hold redo data before writing to redo log files?
A) Buffer Cache
B) Shared Pool
C) Redo Log Buffer
D) Large Pool
Correct Answer: C) Redo Log Buffer
The Redo Log Buffer is a memory area that temporarily stores redo entries until they are written to
online redo log files by the LGWR process.
12. Which optional SGA area is primarily used for backup operations and parallel queries?
A) Java Pool
B) Streams Pool
C) Shared Pool
D) Large Pool
, Correct Answer: D) Large Pool
The Large Pool is an optional memory area that provides memory for large I/O operations, backup
operations, and parallel query execution.
13. Which background process writes dirty data blocks from the buffer cache to datafiles?
A) LGWR
B) CKPT
C) DBWn
D) SMON
Correct Answer: C) DBWn
The Database Writer (DBWn) process writes modified data blocks from the buffer cache to datafiles
when the buffer cache becomes full or checkpoints occur.
14. What background process writes redo log buffer contents to online redo log files?
A) DBWn
B) CKPT
C) LGWR
D) SMON
Correct Answer: C) LGWR
The Log Writer (LGWR) process writes redo entries from the redo log buffer to online redo log files
during commit operations and when buffer is full.
15. Which process signals DBWn to write data and updates file headers during checkpoint
operations?
A) LGWR
B) CKPT
C) SMON
D) PMON
Correct Answer: B) CKPT
The Checkpoint process (CKPT) updates control files and datafile headers with checkpoint information
and signals DBWn to write dirty buffers.
16. What is the primary responsibility of the SMON background process?
A) Clean up failed user sessions
B) Perform instance recovery during startup
C) Write redo log entries
D) Archive redo logs
