- web.groovymark@gmail.com
- December 5, 2024
Question 01
Which of the following is the correct order of Oracle’s storage hierarchy from smallest to largest?
A) Segment, extent, database block, operating-system block
B) Operating-system block, database block, extent, segment
C) Operating-system block, segment, extent, database block
D) Database block, operating-system block, extent, segment
Correct Answer: B) Operating-system block, database block, extent, segment
Explanation: The hierarchy begins with operating-system blocks, which make up database blocks. Database blocks then make up extents, which finally make up segments.
Question 02
What happens when the PMON process is terminated in Oracle Database?
A) Oracle spawns another PMON process automatically
B) The database hangs and the DBA must manually start the PMON process
C) The database crashes and must be restarted
D) PMON is not critical, and the instance continues running
Correct Answer: C) The database crashes and must be restarted
Explanation: PMON is a critical background process. If it is terminated, the entire Oracle instance will crash, and it needs to be restarted.
Question 03
When a user commits a transaction, which background process is responsible for writing the transaction details to the redo log files?
A) DBWn
B) LGWR
C) CKPT
D) SMON
Correct Answer: B) LGWR
Explanation: The LGWR (Log Writer) background process is responsible for writing the redo log buffer to the redo log files upon commit.
Question 04
Which of the following startup modes is used when creating a new database?
A) STARTUP FORCE
B) STARTUP MOUNT
C) STARTUP RESTRICT
D) STARTUP NOMOUNT
Correct Answer: D) STARTUP NOMOUNT
Explanation: The NOMOUNT mode is used when creating a new database, as it only starts the Oracle instance without mounting or opening the database.
Question 05
Which process is responsible for performing instance recovery after a database crash?
A) LGWR
B) SMON
C) CKPT
D) PMON
Correct Answer: B) SMON
Explanation: SMON (System Monitor) is responsible for instance recovery by rolling forward changes from the redo log files.
Question 06
In Oracle RAC, which statement best describes a RAC configuration?
A) One database, multiple instances
B) One instance, multiple databases
C) Multiple databases on different servers
D) Multiple databases, multiple instances
Correct Answer: A) One database, multiple instances
Explanation: In Real Application Clusters (RAC), multiple instances (on different nodes) share a single database.
Question 07
Which component of the SGA stores parsed SQL statements?
A) Database buffer cache
B) Redo log buffer
C) Library cache
D) Large pool
Correct Answer: C) Library cache
Explanation: The library cache contains the parsed SQL statements in the shared pool, allowing reuse of SQL execution plans.
Question 08
Which of the following processes cleans up after a user session is terminated?
A) SMON
B) PMON
C) DBWn
D) CKPT
Correct Answer: B) PMON
Explanation: PMON (Process Monitor) is responsible for cleaning up failed user processes and releasing resources, such as locks.
Question 09
Which background process writes the dirty blocks from the database buffer cache to the data files?
A) DBWn
B) LGWR
C) SMON
D) CKPT
Correct Answer: A) DBWn
Explanation: DBWn (Database Writer) writes dirty blocks from the buffer cache to data files to ensure that changes are persisted.
Question 10
Which of the following SGA components would you increase to ensure that RMAN tape backups do not use memory from the shared pool?
A) Large pool
B) Java pool
C) Streams pool
D) Redo log buffer
Correct Answer: A) Large pool
Explanation: The large pool is used by RMAN to prevent it from using the shared pool memory.
Question 11
Which startup mode would be used to allow only DBA users to connect to the database?
A) STARTUP FORCE
B) STARTUP RESTRICT
C) STARTUP NOMOUNT
D) STARTUP MOUNT
Correct Answer: B) STARTUP RESTRICT
Explanation: STARTUP RESTRICT allows only users with DBA privileges to connect, preventing general users from accessing the database.
Question 12
Which of the following components is part of the Oracle database, not the Oracle instance?
A) System Global Area (SGA)
B) Control file
C) Process monitor
D) Shared pool
Correct Answer: B) Control file
Explanation: Control files, data files, and redo log files are part of the Oracle database, while the other options are part of the Oracle instance.
Question 13
Which data dictionary view would you query to find the current status of redo log groups?
A) V$REDOLOG
B) V$LOGFILE
C) V$LOG
D) V$DATABASE
Correct Answer: C) V$LOG
Explanation: V$LOG contains information about redo log groups and their current status.
Question 14
Which Oracle file is updated with the checkpoint position during an incremental checkpoint?
A) Control file
B) Data files
C) Redo log files
D) Parameter files
Correct Answer: A) Control file
Explanation: The control file is updated with the checkpoint position during incremental checkpoints.
Question 15
Which background process is responsible for writing the checkpoint information to the control files?
A) LGWR
B) CKPT
C) SMON
D) DBWn
Correct Answer: B) CKPT
Explanation: The CKPT (Checkpoint) process updates the control files and data file headers with the checkpoint information.
Question 16
Which component of the Oracle database architecture includes the system global area (SGA) and background processes?
A) Oracle database
B) Oracle instance
C) Oracle schema
D) Oracle segment
Correct Answer: B) Oracle instance
Explanation: The Oracle instance consists of the SGA and background processes, such as PMON, SMON, and DBWn.
Question 17
In which file can you find information on Oracle database errors such as ORA-00600?
A) Listener log
B) Data files
C) Control files
D) Alert log
Correct Answer: D) Alert log
Explanation: The alert log contains information about critical errors, such as ORA-00600, as well as administrative activities like startup and shutdown.
Question 18
Which background process is responsible for archiving redo logs in ARCHIVELOG mode?
A) DBWn
B) ARCn
C) SMON
D) PMON
Correct Answer: B) ARCn
Explanation: ARCn (Archiver) copies redo logs to archive log files when the database is in ARCHIVELOG mode.
Question 19
Which of the following SQL statements will show the redo log groups required for instance crash recovery?
A) SELECT GROUP# FROM V$REDOLOG;
B) SELECT GROUP#, STATUS FROM V$LOG;
C) SELECT * FROM V$LOGFILE;
D) SELECT * FROM V$ARCHIVED_LOG;
Correct Answer: B) SELECT GROUP#, STATUS FROM V$LOG;
Explanation: The V$LOG view contains the status of redo log groups, and those with statuses of CURRENT or ACTIVE are needed for crash recovery.
Question 20
What is the primary purpose of the data dictionary in an Oracle database?
A) Store user data
B) Store metadata about database objects
C) Store redo log information
D) Store configuration parameters
Correct Answer: B) Store metadata about database objects
Explanation: The data dictionary contains metadata about database objects, such as tables, indexes, users, and roles.