D330 Data Systems Administration - Set 4 - Part 1

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

Question 1: Which SQL statement changes the default permanent tablespace for a user?

ALTER USER SET DEFAULT PERMANENT TABLESPACE users;

ALTER USER SET PERMANENT TABLESPACE users;

ALTER USER SET DEFAULT TABLESPACE users;

ALTER USER DEFAULT PERMANENT TABLESPACE users;

Question 2: Which Oracle background process is responsible for cleaning up after failed user processes?

DBWn

LGWR

PMON

CKPT

Question 3: Which of the following views can be used to check the free space available in a tablespace?

DBA_DATA_FILES

DBA_SEGMENTS

DBA_FREE_SPACE

DBA_TABLESPACES

Question 4: What is the default behavior when an Oracle instance crashes?

The database performs a clean shutdown.

The database hangs until manually restarted.

The database automatically restarts.

The instance recovery occurs automatically upon the next startup.

Question 5: Which SQL statement is used to rename a data file in Oracle?

ALTER SYSTEM RENAME DATAFILE;

ALTER DATABASE RENAME FILE;

ALTER FILE RENAME DATAFILE;

ALTER DATAFILE RENAME;

Question 6: Which Oracle background process writes the contents of the database buffer cache to the data files?

CKPT

LGWR

DBWn

SMON

Question 7: Which SQL statement is used to take a tablespace offline?

ALTER DATABASE TABLESPACE OFFLINE;

ALTER SYSTEM TABLESPACE OFFLINE;

ALTER TABLESPACE OFFLINE;

ALTER FILESPACE OFFLINE;

Question 8: Which Oracle feature automatically adjusts memory allocations between the SGA and PGA?

Automatic Memory Management (AMM)

Automatic Storage Management (ASM)

Automatic Segment Space Management (ASSM)

Automatic Data Optimization (ADO)

Question 9: Which Oracle component manages the redo log buffer?

SMON

LGWR

CKPT

DBWn

Question 10: Which command is used to create a control file?

CREATE CONTROLFILE

ALTER DATABASE CREATE CONTROLFILE

CREATE DATABASE CONTROLFILE

ALTER SYSTEM CREATE CONTROLFILE

Question 11: Which Oracle process is responsible for instance recovery?

CKPT

SMON

PMON

DBWn

Question 12: What is the purpose of the Oracle Data Pump utility?

To back up the control files

To export and import database objects

To perform instance recovery

To manage redo log groups

Question 13: Which SQL statement sets a user's quota on a tablespace?

ALTER USER QUOTA ON tablespace;

ALTER USER SET QUOTA tablespace;

ALTER USER SET QUOTA ON tablespace;

ALTER USER SET TABLESPACE QUOTA;

Question 14: Which background process in Oracle writes the checkpoint information to the control file and data file headers?

DBWn

LGWR

CKPT

SMON

Question 15: What does the DBA_TAB_COLUMNS view contain?

Information about the columns of all tables

Information about tablespaces

Information about users

Information about privileges

Question 16: Which SQL statement enables archiving in an Oracle database?

ALTER DATABASE ENABLE ARCHIVELOG;

ALTER SYSTEM SET ARCHIVELOG ON;

ALTER DATABASE ARCHIVELOG;

ALTER SYSTEM ENABLE ARCHIVELOG;

Question 17: Which of the following views provides information about the control files?

V$CONTROLFILE

V$DATABASE

V$DATAFILE

V$INSTANCE

Question 18: What is the primary purpose of the Oracle Database Resource Manager (DBRM)?

To manage redo log writing

To prioritize CPU and I/O resources

To monitor tablespace usage

To handle background process failures

Question 19: Which SQL statement resizes a data file?

ALTER SYSTEM DATAFILE RESIZE 'filename' SIZE 500M;

ALTER DATABASE DATAFILE 'filename' RESIZE 500M;

ALTER DATAFILE RESIZE 'filename';

ALTER DATABASE RESIZE DATAFILE 'filename';

Question 20: Which background process is responsible for writing the contents of the redo log buffer to disk?

LGWR

CKPT

DBWn

SMON

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support