D330 Data Systems Administration - Set 4 - Part 2

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 21: Which view provides information about the active sessions in an Oracle database?

V$SESSION

V$INSTANCE

V$DATABASE

V$PROCESS

Question 22: Which SQL statement disables automatic undo management in Oracle?

ALTER SYSTEM SET UNDO_MANAGEMENT=MANUAL;

ALTER SYSTEM SET UNDO_MANAGEMENT=OFF;

ALTER DATABASE SET UNDO_MANAGEMENT=MANUAL;

ALTER DATABASE UNDO_MANAGEMENT OFF;

Question 23: Which Oracle feature allows a single database to support multiple tenants or users?

Automatic Data Optimization

Multitenant Architecture

Data Guard

Oracle Streams

Question 24: Which SQL statement is used to drop a data file from a tablespace?

ALTER SYSTEM DROP DATAFILE;

ALTER TABLESPACE DROP DATAFILE;

ALTER DATABASE DATAFILE DROP;

ALTER DATAFILE DROP;

Question 25: What happens when the Oracle instance reaches the maximum number of sessions allowed by the SESSIONS initialization parameter?

The database shuts down.

New connections are rejected.

Existing connections are terminated.

The database goes into restricted mode.

Question 26: Which SQL statement is used to enable force logging mode in an Oracle database?

ALTER DATABASE ENABLE FORCE LOGGING;

ALTER SYSTEM ENABLE FORCE LOGGING;

ALTER DATABASE FORCE LOGGING;

ALTER SYSTEM FORCE LOGGING;

Question 27: Which Oracle background process is responsible for writing the contents of the redo log buffer to the redo log files?

DBWn

LGWR

CKPT

SMON

Question 28: Which SQL statement is used to modify a user's profile in Oracle?

ALTER PROFILE profile_name MODIFY;

ALTER USER SET PROFILE profile_name;

ALTER PROFILE profile_name LIMIT;

ALTER USER MODIFY PROFILE profile_name;

Question 29: Which of the following Oracle database objects is used to store undo information?

Redo log files

Data files

Undo tablespaces

Control files

Question 30: Which command is used to check the status of a database in Oracle?

SELECT * FROM V$STATUS;

SELECT * FROM DBA_STATUS;

SELECT STATUS FROM V$INSTANCE;

SELECT STATUS FROM V$DATABASE;

Question 31: Which of the following SQL statements puts the database in restricted mode?

ALTER DATABASE START RESTRICTED;

ALTER DATABASE RESTRICT;

ALTER SYSTEM SET RESTRICTED SESSION=TRUE;

ALTER SYSTEM ENABLE RESTRICTED MODE;

Question 32: What is the purpose of the Oracle SMON process?

To clean up failed user processes

To manage the redo log buffer

To recover the database after an instance failure

To perform checkpoint operations

Question 33: Which Oracle background process is responsible for managing the buffer cache and writing dirty buffers to disk?

CKPT

LGWR

DBWn

SMON

Question 34: Which SQL statement is used to set the number of redo log files in an Oracle database?

ALTER DATABASE ADD LOGFILE GROUP;

ALTER SYSTEM SET LOGFILE GROUP;

ALTER DATABASE SET REDO LOGFILES;

ALTER SYSTEM ADD LOGFILE GROUP;

Question 35: Which command is used to manually create a backup control file in Oracle?

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

ALTER DATABASE BACKUP CONTROLFILE TO FILE;

ALTER SYSTEM BACKUP CONTROLFILE TO FILE;

ALTER DATABASE BACKUP CONTROLFILE;

Question 36: Which Oracle background process writes checkpoint information to the control files?

SMON

CKPT

DBWn

LGWR

Question 37: Which of the following views contains information about database instances in an Oracle system?

V$INSTANCE

V$SESSION

V$CONTROLFILE

V$DATAFILE

Question 38: Which SQL command is used to take a tablespace offline?

ALTER SYSTEM OFFLINE TABLESPACE tablespace_name;

ALTER TABLESPACE tablespace_name OFFLINE;

ALTER DATABASE OFFLINE TABLESPACE tablespace_name;

ALTER SYSTEM SET OFFLINE TABLESPACE tablespace_name;

Question 39: Which SQL statement is used to enable archiving in an Oracle database?

ALTER SYSTEM ENABLE ARCHIVELOG MODE;

ALTER DATABASE ENABLE ARCHIVELOG MODE;

ALTER DATABASE ARCHIVELOG;

ALTER SYSTEM SET ARCHIVELOG;

Question 40: What is the purpose of the Oracle control file?

To store data for user tables

To store the contents of the redo log buffer

To maintain the metadata about the database structure

To manage user sessions

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support