-
web.groovymark@gmail.com
- December 5, 2024
Question 21
Which view provides information about the active sessions in an Oracle database?
A) V$SESSION
B) V$INSTANCE
C) V$DATABASE
D) V$PROCESS
Correct Answer: A) V$SESSION
Explanation: V$SESSION contains information about the currently active sessions in an Oracle database.
Question 22
Which SQL statement disables automatic undo management in Oracle?
A) ALTER SYSTEM SET UNDO_MANAGEMENT=MANUAL;
B) ALTER SYSTEM SET UNDO_MANAGEMENT=OFF;
C) ALTER DATABASE SET UNDO_MANAGEMENT=MANUAL;
D) ALTER DATABASE UNDO_MANAGEMENT OFF;
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
Which Oracle feature allows a single database to support multiple tenants or users?
A) Automatic Data Optimization
B) Multitenant Architecture
C) Data Guard
D) Oracle Streams
Correct Answer: B) Multitenant Architecture
Explanation: The Multitenant Architecture allows a single Oracle database to support multiple tenants or users.
Question 24
Which SQL statement is used to drop a data file from a tablespace?
A) ALTER SYSTEM DROP DATAFILE;
B) ALTER TABLESPACE DROP DATAFILE;
C) ALTER DATABASE DATAFILE DROP;
D) ALTER DATAFILE DROP;
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
What happens when the Oracle instance reaches the maximum number of sessions allowed by the SESSIONS initialization parameter?
A) The database shuts down.
B) New connections are rejected.
C) Existing connections are terminated.
D) The database goes into restricted mode.
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
Which SQL statement is used to enable force logging mode in an Oracle database?
A) ALTER DATABASE ENABLE FORCE LOGGING;
B) ALTER SYSTEM ENABLE FORCE LOGGING;
C) ALTER DATABASE FORCE LOGGING;
D) ALTER SYSTEM FORCE LOGGING;
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
Which Oracle background process is responsible for writing the contents of the redo log buffer to the redo log files?
A) DBWn
B) LGWR
C) CKPT
D) SMON
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
Which SQL statement is used to modify a user’s profile in Oracle?
A) ALTER PROFILE profile_name MODIFY;
B) ALTER USER SET PROFILE profile_name;
C) ALTER PROFILE profile_name LIMIT;
D) ALTER USER MODIFY PROFILE profile_nam
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
Which of the following Oracle database objects is used to store undo information?
A) Redo log files
B) Data files
C) Undo tablespaces
D) Control files
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
Which command is used to check the status of a database in Oracle?
A) SELECT * FROM V$STATUS;
B) SELECT * FROM DBA_STATUS;
C) SELECT STATUS FROM V$INSTANCE;
D) SELECT STATUS FROM V$DATABASE;
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
Which of the following SQL statements puts the database in restricted mode?
A) ALTER DATABASE START RESTRICTED;
B) ALTER DATABASE RESTRICT;
C) ALTER SYSTEM SET RESTRICTED SESSION=TRUE;
D) ALTER SYSTEM ENABLE 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
What is the purpose of the Oracle SMON process?
A) To clean up failed user processes
B) To manage the redo log buffer
C) To recover the database after an instance failure
D) To perform checkpoint operations
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
Which Oracle background process is responsible for managing the buffer cache and writing dirty buffers to disk?
A) CKPT
B) LGWR
C) DBWn
D) SMON
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
Which SQL statement is used to set the number of redo log files in an Oracle database?
A) ALTER DATABASE ADD LOGFILE GROUP;
B) ALTER SYSTEM SET LOGFILE GROUP;
C) ALTER DATABASE SET REDO LOGFILES;
D) ALTER SYSTEM ADD LOGFILE GROUP;
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
Which command is used to manually create a backup control file in Oracle?
A) ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
B) ALTER DATABASE BACKUP CONTROLFILE TO FILE;
C) ALTER SYSTEM BACKUP CONTROLFILE TO FILE;
D) ALTER DATABASE BACKUP CONTROLFILE;
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
Which Oracle background process writes checkpoint information to the control files?
A) SMON
B) CKPT
C) DBWn
D) LGWR
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
Which of the following views contains information about database instances in an Oracle system?
A) V$INSTANCE
B) V$SESSION
C) V$CONTROLFILE
D) V$DATAFILE
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
Which SQL command is used to take a tablespace offline?
A) ALTER SYSTEM OFFLINE TABLESPACE tablespace_name;
B) ALTER TABLESPACE tablespace_name OFFLINE;
C) ALTER DATABASE OFFLINE TABLESPACE tablespace_name;
D) ALTER SYSTEM SET OFFLINE TABLESPACE tablespace_name;
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
Which SQL statement is used to enable archiving in an Oracle database?
A) ALTER SYSTEM ENABLE ARCHIVELOG MODE;
B) ALTER DATABASE ENABLE ARCHIVELOG MODE;
C) ALTER DATABASE ARCHIVELOG;
D) ALTER SYSTEM SET ARCHIVELOG;
Correct Answer: C) ALTER DATABASE ARCHIVELOG;
Explanation: The correct SQL statement to enable archiving is ALTER DATABASE ARCHIVELOG.
Question 40
What is the purpose of the Oracle control file?
A) To store data for user tables
B) To store the contents of the redo log buffer
C) To maintain the metadata about the database structure
D) To manage user sessions
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.
