50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
Which of the following is the correct order of Oracle’s storage hierarchy from smallest to largest?
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 2 of 50
What happens when the PMON process is terminated in Oracle Database?
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 3 of 50
When a user commits a transaction, which background process is responsible for writing the transaction details to the redo log files?
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 4 of 50
Which of the following startup modes is used when creating a new database?
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 5 of 50
Which process is responsible for performing instance recovery after a database crash?
Correct answer: B) SMON
Explanation: SMON (System Monitor) is responsible for instance recovery by rolling forward changes from the redo log files.
Question 6 of 50
In Oracle RAC, which statement best describes a RAC configuration?
Correct answer: A) One database, multiple instances
Explanation: In Real Application Clusters (RAC), multiple instances (on different nodes) share a single database.
Question 7 of 50
Which component of the SGA stores parsed SQL statements?
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 8 of 50
Which of the following processes cleans up after a user session is terminated?
Correct answer: B) PMON
Explanation: PMON (Process Monitor) is responsible for cleaning up failed user processes and releasing resources, such as locks.
Question 9 of 50
Which background process writes the dirty blocks from the database buffer cache to the data files?
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 of 50
Which of the following SGA components would you increase to ensure that RMAN tape backups do not use memory from the shared pool?
Correct answer: A) Large pool
Explanation: The large pool is used by RMAN to prevent it from using the shared pool memory.
Question 11 of 50
Which startup mode would be used to allow only DBA users to connect to the database?
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 of 50
Which of the following components is part of the Oracle database, not the Oracle instance?
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 of 50
Which data dictionary view would you query to find the current status of redo log groups?
Correct answer: C) V$LOG
Explanation: V$LOG contains information about redo log groups and their current status.
Question 14 of 50
Which Oracle file is updated with the checkpoint position during an incremental checkpoint?
Correct answer: A) Control file
Explanation: The control file is updated with the checkpoint position during incremental checkpoints.
Question 15 of 50
Which background process is responsible for writing the checkpoint information to the control files?
Correct answer: B) CKPT
Explanation: The CKPT (Checkpoint) process updates the control files and data file headers with the checkpoint information.
Question 16 of 50
Which component of the Oracle database architecture includes the system global area (SGA) and background processes?
Correct answer: B) Oracle instance
Explanation: The Oracle instance consists of the SGA and background processes, such as PMON, SMON, and DBWn.
Question 17 of 50
In which file can you find information on Oracle database errors such as ORA-00600?
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 of 50
Which background process is responsible for archiving redo logs in ARCHIVELOG mode?
Correct answer: B) ARCn
Explanation: ARCn (Archiver) copies redo logs to archive log files when the database is in ARCHIVELOG mode.
Question 19 of 50
Which of the following SQL statements will show the redo log groups required for instance crash recovery?
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 of 50
What is the primary purpose of the data dictionary in an Oracle database?
Correct answer: B) Store metadata about database objects
Explanation: The data dictionary contains metadata about database objects, such as tables, indexes, users, and roles.
Question 21 of 50
Which SQL statement is used to view the current values of initialization parameters?
Correct answer: B) SELECT * FROM V$PARAMETER;
Explanation: V$PARAMETER displays the current values of initialization parameters for the running Oracle instance.
Question 22 of 50
When using a binary initialization parameter file (spfile), which clause would ensure that changes to parameters are persisted across restarts?
Correct answer: B) ALTER SYSTEM SET parameter=value SCOPE=BOTH;
Explanation: SCOPE=BOTH applies the changes in memory and saves them in the spfile, ensuring persistence across restarts.
Question 23 of 50
Which of the following statements is true regarding the SYSTEM tablespace in an Oracle database
Correct answer: C) Its data files can be renamed.
Explanation: Data files in the SYSTEM tablespace can be renamed, but only when the database is in the MOUNT state.
Question 24 of 50
Which of the following components is stored in a tablespace in an Oracle database?
Correct answer: C) Temporary segment
Explanation: Temporary segments are stored in a tablespace, while control files and redo log files are stored outside tablespaces.
Question 25 of 50
What SQL statement would you issue to make a tablespace read-only?
Correct answer: C) ALTER TABLESPACE READ ONLY;
Explanation: The correct SQL statement to make a tablespace read-only is ALTER TABLESPACE READ ONLY.
Question 26 of 50
Which of the following views can be used to monitor tablespace utilization?
Correct answer: D) DBA_FREE_SPACE
Explanation: DBA_FREE_SPACE contains information about free space in tablespaces and can be used to monitor tablespace utilization.
Question 27 of 50
Which background process ensures that committed transactions are written to disk even if they have not yet been written to the data files?
Correct answer: B) LGWR
Explanation: LGWR writes committed transactions to the redo log files, ensuring data persistence even if the data files are not yet updated.
Question 28 of 50
What happens when the ALTER SYSTEM command is used to change the value of an initialization parameter in a pfile?
Correct answer: C) The change is not applied until the database is restarted.
Explanation: When using a pfile, changes to initialization parameters are not applied until the database is restarte
Question 29 of 50
What is the purpose of the DBMS_FGA package in Oracle?
Correct answer: A) To manage fine-grained auditing policies
Explanation: The DBMS_FGA package is used to define and manage fine-grained auditing policies in Oracle.
Question 30 of 50
Which view can be queried to monitor session activity and resource usage in an Oracle database?
Correct answer: A) V$SESSION
Explanation: V$SESSION displays information about the currently active sessions and resource usage in the database.
Question 31 of 50
Which statement is true regarding the ALTER TABLESPACE command in Oracle?
Correct answer: B) It can be used to resize data files.
Explanation: The ALTER TABLESPACE command can be used to resize data files within a tablespace.
Question 32 of 50
Which background process coalesces free space in dictionary-managed tablespaces?
Correct answer: C) SMON
Explanation: SMON (System Monitor) is responsible for coalescing free space in dictionary-managed tablespaces.
Question 33 of 50
Which SQL statement is used to add more space to an existing tablespace by increasing the size of a data file?
Correct answer: C) ALTER DATABASE DATAFILE ‘filename’ RESIZE 500M;
Explanation: The ALTER DATABASE DATAFILE statement is used to resize an existing data file.
Question 34 of 50
What is the minimum number of redo log groups required in an Oracle database?
Correct answer: B) Two
Explanation: An Oracle database requires at least two redo log groups for proper functioning and to provide redundancy.
Question 35 of 50
Which of the following SQL statements is used to bring a tablespace online?
Correct answer: C) ALTER TABLESPACE ONLINE;
Explanation: ALTER TABLESPACE ONLINE is the correct statement to bring a tablespace online.
Question 36 of 50
What privilege is required to create a private database link?
Correct answer: C) CREATE DATABASE LINK
Explanation: The CREATE DATABASE LINK privilege is required to create a private database link.
Question 37 of 50
What does the ALTER SYSTEM FLUSH SHARED_POOL command do in Oracle?
Correct answer: B) Flushes the shared pool and removes all cached SQL statements
Explanation: The ALTER SYSTEM FLUSH SHARED_POOL command clears the shared pool by removing all cached SQL and PL/SQL statements.
Question 38 of 50
Which of the following is true about Oracle’s automatic segment space management (ASSM)?
Correct answer: A) ASSM uses bitmaps to manage free space.
Explanation: ASSM uses bitmaps to automatically manage and track free space in segments.
Question 39 of 50
Which view would you query to find out which data files are part of a tablespace?
Correct answer: C) DBA_DATA_FILES
Explanation: DBA_DATA_FILES contains information about the data files belonging to each table
Question 40 of 50
Which SQL statement disables automatic archiving in Oracle?
Correct answer: C) ALTER DATABASE NOARCHIVELOG;
Explanation: The correct statement to disable automatic archiving is ALTER DATABASE NOARCHIVELOG.
Question 41 of 50
What is the purpose of the Oracle Scheduler?
Correct answer: B) To schedule and run jobs
Explanation: The Oracle Scheduler is used to schedule and run jobs, such as batch processing or maintenance tasks.
Question 42 of 50
Which of the following statements is true about Oracle Managed Files (OMF)?
Correct answer: B) OMF automatically creates and manages data files.
Explanation: Oracle Managed Files (OMF) allows Oracle to automatically manage the creation and deletion of data files.
Question 43 of 50
Which of the following SQL statements creates an undo tablespace?