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 SQL statement changes the default permanent tablespace for a user?
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 2 of 50
Which Oracle background process is responsible for cleaning up after failed user processes?
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 3 of 50
Which of the following views can be used to check the free space available in a tablespace?
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 4 of 50
What is the default behavior when an Oracle instance crashes?
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 5 of 50
Which SQL statement is used to rename a data file in Oracle?
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 6 of 50
Which Oracle background process writes the contents of the database buffer cache to the data files?
Correct answer: C) DBWn
Explanation: The DBWn (Database Writer) process writes the contents of the buffer cache to the data files.
Question 7 of 50
Which SQL statement is used to take a tablespace offline?
Correct answer: C) ALTER TABLESPACE OFFLINE;
Explanation: The correct statement to take a tablespace offline is ALTER TABLESPACE OFFLINE.
Question 8 of 50
Which Oracle feature automatically adjusts memory allocations between the SGA and PGA?
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 9 of 50
Which Oracle component manages the redo log buffer?
Correct answer: B) LGWR
Explanation: LGWR (Log Writer) manages the redo log buffer and writes its contents to the redo log files.
Question 10 of 50
Which command is used to create a control file?
Correct answer: A) CREATE CONTROLFILE
Explanation: The correct statement to create a control file is CREATE CONTROLFILE.
Question 11 of 50
Which Oracle process is responsible for instance recovery?
Correct answer: B) SMON
Explanation: SMON (System Monitor) is responsible for instance recovery when an Oracle instance is restarted.
Question 12 of 50
What is the purpose of the Oracle Data Pump utility?
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 of 50
Which SQL statement sets a user’s quota on a tablespace?
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 of 50
Which background process in Oracle writes the checkpoint information to the control file and data file headers?
Correct answer: C) CKPT
Explanation: CKPT (Checkpoint) writes checkpoint information to control files and data file headers.
Question 15 of 50
What does the DBA_TAB_COLUMNS view contain?
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 of 50
Which SQL statement enables archiving in an Oracle database?
Correct answer: C) ALTER DATABASE ARCHIVELOG;
Explanation: The correct statement to enable archiving is ALTER DATABASE ARCHIVELOG.
Question 17 of 50
Which of the following views provides information about the control files?
Correct answer: A) V$CONTROLFILE
Explanation: V$CONTROLFILE provides information about the control files in an Oracle database.
Question 18 of 50
What is the primary purpose of the Oracle Database Resource Manager (DBRM)?
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 of 50
Which SQL statement resizes a data file?
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 of 50
Which background process is responsible for writing the contents of the redo log buffer to disk?
Correct answer: A) LGWR
Explanation: LGWR (Log Writer) writes the contents of the redo log buffer to the redo log files on disk.
Question 21 of 50
Which view provides information about the active sessions in an Oracle database?
Correct answer: A) V$SESSION
Explanation: V$SESSION contains information about the currently active sessions in an Oracle database.
Question 22 of 50
Which SQL statement disables automatic undo management in Oracle?
Correct answer: A) ALTER SYSTEM SET UNDO_MANAGEMENT=MANUAL;
Explanation: The correct SQL statement to disable automatic undo management is ALTER SYSTEM SET UNDO_MANAGEMENT=MANUAL.
Question 23 of 50
Which Oracle feature allows a single database to support multiple tenants or users?
Correct answer: B) Multitenant Architecture
Explanation: The Multitenant Architecture allows a single Oracle database to support multiple tenants or users.
Question 24 of 50
Which SQL statement is used to drop a data file from a tablespace?
Correct answer: B) ALTER TABLESPACE DROP DATAFILE;
Explanation: The correct statement to drop a data file from a tablespace is ALTER TABLESPACE DROP DATAFILE.
Question 25 of 50
What happens when the Oracle instance reaches the maximum number of sessions allowed by the SESSIONS initialization parameter?
Correct answer: B) New connections are rejected.
Explanation: When the maximum number of sessions is reached, new connections are rejected until other sessions are terminated or the parameter is increased.
Question 26 of 50
Which SQL statement is used to enable force logging mode in an Oracle database?
Correct answer: A) ALTER DATABASE ENABLE FORCE LOGGING;
Explanation: The correct statement to enable force logging mode in an Oracle database is ALTER DATABASE ENABLE FORCE LOGGING.
Question 27 of 50
Which Oracle background process is responsible for writing the contents of the redo log buffer to the redo log files?
Correct answer: B) LGWR
Explanation: LGWR (Log Writer) is responsible for writing the contents of the redo log buffer to the redo log files.
Question 28 of 50
Which SQL statement is used to modify a user’s profile in Oracle?
Correct answer: C) ALTER PROFILE profile_name LIMIT;
Explanation: The correct SQL statement to modify a user's profile is ALTER PROFILE profile_name LIMIT.
Question 29 of 50
Which of the following Oracle database objects is used to store undo information?
Correct answer: C) Undo tablespaces
Explanation: Undo information is stored in undo tablespaces, which are used to maintain transactional information for rollback purposes.
Question 30 of 50
Which command is used to check the status of a database in Oracle?
Correct answer: C) SELECT STATUS FROM V$INSTANCE;
Explanation: The correct command to check the status of a database instance is SELECT STATUS FROM V$INSTANCE.
Question 31 of 50
Which of the following SQL statements puts the database in restricted mode?
Correct answer: C) ALTER SYSTEM SET RESTRICTED SESSION=TRUE;
Explanation: The correct SQL statement to enable restricted mode in an Oracle database is ALTER SYSTEM SET RESTRICTED SESSION=TRUE.
Question 32 of 50
What is the purpose of the Oracle SMON process?
Correct answer: C) To recover the database after an instance failure
Explanation: SMON (System Monitor) is responsible for recovering the database after an instance failure and performing tasks such as cleaning up temporary segments.
Question 33 of 50
Which Oracle background process is responsible for managing the buffer cache and writing dirty buffers to disk?
Correct answer: C) DBWn
Explanation: DBWn (Database Writer) is responsible for managing the buffer cache and writing dirty buffers (modified data) to disk.
Question 34 of 50
Which SQL statement is used to set the number of redo log files in an Oracle database?
Correct answer: A) ALTER DATABASE ADD LOGFILE GROUP;
Explanation: The correct SQL statement to set the number of redo log files is ALTER DATABASE ADD LOGFILE GROUP.
Question 35 of 50
Which command is used to manually create a backup control file in Oracle?
Correct answer: A) ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Explanation: The correct SQL command to create a backup control file is ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
Question 36 of 50
Which Oracle background process writes checkpoint information to the control files?
Correct answer: B) CKPT
Explanation: CKPT (Checkpoint) writes checkpoint information to control files and data file headers, allowing the system to know the point at which recovery should start after an instance failure.
Question 37 of 50
Which of the following views contains information about database instances in an Oracle system?
Correct answer: A) V$INSTANCE
Explanation: The V$INSTANCE view contains information about the Oracle database instance, including status, database name, and startup time.
Question 38 of 50
Which SQL command is used to take a tablespace offline?
Correct answer: B) ALTER TABLESPACE tablespace_name OFFLINE;
Explanation: The correct SQL statement to take a tablespace offline is ALTER TABLESPACE tablespace_name OFFLINE.
Question 39 of 50
Which SQL statement is used to enable archiving in an Oracle database?
Correct answer: C) ALTER DATABASE ARCHIVELOG;
Explanation: The correct SQL statement to enable archiving is ALTER DATABASE ARCHIVELOG.
Question 40 of 50
What is the purpose of the Oracle control file?
Correct answer: C) To maintain the metadata about the database structure
Explanation: The control file stores critical information about the database structure, such as data file and redo log file locations and database name.
Question 41 of 50
Which SQL statement creates a database link in Oracle?
Correct answer: A) CREATE DATABASE LINK link_name;
Explanation: The correct SQL statement to create a database link is CREATE DATABASE LINK link_name.
Question 42 of 50
Which view provides information about the data files in an Oracle database?
Correct answer: B) V$DATAFILE
Explanation: V$DATAFILE provides information about the data files in an Oracle database, including their status and locations.
Question 43 of 50
Which Oracle background process monitors the state of the database and handles recovery tasks after a failure?
Correct answer: A) SMON
Explanation: SMON (System Monitor) monitors the state of the database and handles recovery tasks such as instance recovery after a failure.
Question 44 of 50
Which of the following commands is used to modify the size of an Oracle data file?
Correct answer: B) ALTER DATABASE RESIZE DATAFILE;
Explanation: The correct command to modify the size of an Oracle data file is ALTER DATABASE RESIZE DATAFILE.
Question 45 of 50
Which SQL statement is used to enable restricted session mode in Oracle?
Correct answer: B) ALTER SYSTEM SET RESTRICTED SESSION=TRUE;
Explanation: The correct SQL statement to enable restricted session mode is ALTER SYSTEM SET RESTRICTED SESSION=TRUE.
Question 46 of 50
Which of the following is used to configure memory allocation for the shared pool in Oracle?
Correct answer: B) SHARED_POOL_SIZE
Explanation: SHARED_POOL_SIZE is used to configure memory allocation for the shared pool in Oracle.
Question 47 of 50
Which SQL statement sets the default undo tablespace for an Oracle database?
Correct answer: A) ALTER SYSTEM SET UNDO_TABLESPACE=undo_tablespace_name;
Explanation: The correct SQL statement to set the default undo tablespace is ALTER SYSTEM SET UNDO_TABLESPACE.
Question 48 of 50
Which SQL statement enables force logging mode in an Oracle database?
Correct answer: B) ALTER DATABASE ENABLE FORCE LOGGING;
Explanation: The correct SQL statement to enable force logging mode is ALTER DATABASE ENABLE FORCE LOGGING.
Question 49 of 50
What happens if the Oracle SYSTEM tablespace runs out of space?
Correct answer: C) The database crashes.
Explanation: If the SYSTEM tablespace runs out of space, the database crashes because the SYSTEM tablespace is critical for database operations.
Question 50 of 50
Which Oracle background process writes the log buffer to the redo log files?
Correct answer: C) LGWR
Explanation: LGWR (Log Writer) writes the contents of the log buffer to the redo log files on disk.
Set 4 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).