-
web.groovymark@gmail.com
- December 5, 2024
Question 01
Which SQL statement changes the default permanent tablespace for a user?
A) ALTER USER SET DEFAULT PERMANENT TABLESPACE users;
B) ALTER USER SET PERMANENT TABLESPACE users;
C) ALTER USER SET DEFAULT TABLESPACE users;
D) ALTER USER DEFAULT PERMANENT TABLESPACE users;
Correct Answer: D) ALTER USER DEFAULT PERMANENT TABLESPACE users;
Explanation: The correct syntax to change a user's default permanent tablespace is ALTER USER DEFAULT PERMANENT TABLESPACE.
Question 02
Which Oracle background process is responsible for cleaning up after failed user processes?
A) DBWn
B) LGWR
C) PMON
D) CKPT
Correct Answer: C) PMON
Explanation: PMON (Process Monitor) is responsible for cleaning up failed user processes and releasing resources such as locks and memory.
Question 03
Which of the following views can be used to check the free space available in a tablespace?
A) DBA_DATA_FILES
B) DBA_SEGMENTS
C) DBA_FREE_SPACE
D) DBA_TABLESPACES
Correct Answer: C) DBA_FREE_SPACE
Explanation: DBA_FREE_SPACE shows the available free space in a tablespace, making it useful for monitoring space usage.
Question 04
What is the default behavior when an Oracle instance crashes?
A) The database performs a clean shutdown.
B) The database hangs until manually restarted.
C) The database automatically restarts.
D) The instance recovery occurs automatically upon the next startup.
Correct Answer: D) The instance recovery occurs automatically upon the next startup.
Explanation: When an Oracle instance crashes, recovery is performed automatically during the next startup using the redo log files.
Question 05
Which SQL statement is used to rename a data file in Oracle?
A) ALTER SYSTEM RENAME DATAFILE;
B) ALTER DATABASE RENAME FILE;
C) ALTER FILE RENAME DATAFILE;
D) ALTER DATAFILE RENAME;
Correct Answer: B) ALTER DATABASE RENAME FILE;
Explanation: The ALTER DATABASE RENAME FILE statement is used to rename a data file in an Oracle database.
Question 06
Which Oracle background process writes the contents of the database buffer cache to the data files?
A) CKPT
B) LGWR
C) DBWn
D) SMON
Correct Answer: C) DBWn
Explanation: The DBWn (Database Writer) process writes the contents of the buffer cache to the data files.
Question 07
Which SQL statement is used to take a tablespace offline?
A) ALTER DATABASE TABLESPACE OFFLINE;
B) ALTER SYSTEM TABLESPACE OFFLINE;
C) ALTER TABLESPACE OFFLINE;
D) ALTER FILESPACE OFFLINE;
Correct Answer: C) ALTER TABLESPACE OFFLINE;
Explanation: The correct statement to take a tablespace offline is ALTER TABLESPACE OFFLINE.
Question 08
Which Oracle feature automatically adjusts memory allocations between the SGA and PGA?
A) Automatic Memory Management (AMM)
B) Automatic Storage Management (ASM)
C) Automatic Segment Space Management (ASSM)
D) Automatic Data Optimization (ADO)
Correct Answer: A) Automatic Memory Management (AMM)
Explanation: Automatic Memory Management (AMM) dynamically adjusts memory allocations between the SGA and PGA based on workload.
Question 09
Which Oracle component manages the redo log buffer?
A) SMON
B) LGWR
C) CKPT
D) DBWn
Correct Answer: B) LGWR
Explanation: LGWR (Log Writer) manages the redo log buffer and writes its contents to the redo log files.
Question 10
Which command is used to create a control file?
A) CREATE CONTROLFILE
B) ALTER DATABASE CREATE CONTROLFILE
C) CREATE DATABASE CONTROLFILE
D) ALTER SYSTEM CREATE CONTROLFILE
Correct Answer: A) CREATE CONTROLFILE
Explanation: The correct statement to create a control file is CREATE CONTROLFILE.
Question 11
Which Oracle process is responsible for instance recovery?
A) CKPT
B) SMON
C) PMON
D) DBWn
Correct Answer: B) SMON
Explanation: SMON (System Monitor) is responsible for instance recovery when an Oracle instance is restarted.
Question 12
What is the purpose of the Oracle Data Pump utility?
A) To back up the control files
B) To export and import database objects
C) To perform instance recovery
D) To manage redo log groups
Correct Answer: B) To export and import database objects
Explanation: Oracle Data Pump is used for high-speed export and import of database objects and data.
Question 13
Which SQL statement sets a user’s quota on a tablespace?
A) ALTER USER QUOTA ON tablespace;
B) ALTER USER SET QUOTA tablespace;
C) ALTER USER SET QUOTA ON tablespace;
D) ALTER USER SET TABLESPACE QUOTA;
Correct Answer: A) ALTER USER QUOTA ON tablespace;
Explanation: The correct SQL statement to set a user's quota on a tablespace is ALTER USER QUOTA ON.
Question 14
Which background process in Oracle writes the checkpoint information to the control file and data file headers?
A) DBWn
B) LGWR
C) CKPT
D) SMON
Correct Answer: C) CKPT
Explanation: CKPT (Checkpoint) writes checkpoint information to control files and data file headers.
Question 15
What does the DBA_TAB_COLUMNS view contain?
A) Information about the columns of all tables
B) Information about tablespaces
C) Information about users
D) Information about privileges
Correct Answer: A) Information about the columns of all tables
Explanation: The DBA_TAB_COLUMNS view contains information about the columns of all tables in the database.
Question 16
Which SQL statement enables archiving in an Oracle database?
A) ALTER DATABASE ENABLE ARCHIVELOG;
B) ALTER SYSTEM SET ARCHIVELOG ON;
C) ALTER DATABASE ARCHIVELOG;
D) ALTER SYSTEM ENABLE ARCHIVELOG;
Correct Answer: C) ALTER DATABASE ARCHIVELOG;
Explanation: The correct statement to enable archiving is ALTER DATABASE ARCHIVELOG.
Question 17
Which of the following views provides information about the control files?
A) V$CONTROLFILE
B) V$DATABASE
C) V$DATAFILE
D) V$INSTANCE
Correct Answer: A) V$CONTROLFILE
Explanation: V$CONTROLFILE provides information about the control files in an Oracle database.
Question 18
What is the primary purpose of the Oracle Database Resource Manager (DBRM)?
A) To manage redo log writing
B) To prioritize CPU and I/O resources
C) To monitor tablespace usage
D) To handle background process failures
Correct Answer: B) To prioritize CPU and I/O resources
Explanation: The Oracle Database Resource Manager (DBRM) is used to allocate and prioritize CPU and I/O resources to database sessions.
Question 19
Which SQL statement resizes a data file?
A) ALTER SYSTEM DATAFILE RESIZE ‘filename’ SIZE 500M;
B) ALTER DATABASE DATAFILE ‘filename’ RESIZE 500M;
C) ALTER DATAFILE RESIZE ‘filename’;
D) ALTER DATABASE RESIZE DATAFILE ‘filename’;
Correct Answer: B) ALTER DATABASE DATAFILE 'filename' RESIZE 500M;
Explanation: The correct statement to resize a data file is ALTER DATABASE DATAFILE 'filename' RESIZE.
Question 20
Which background process is responsible for writing the contents of the redo log buffer to disk?
A) LGWR
B) CKPT
C) DBWn
D) SMON
Correct Answer: A) LGWR
Explanation: LGWR (Log Writer) writes the contents of the redo log buffer to the redo log files on disk.
