D330 Data Systems Administration - Set 3 - 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 of the following is the correct order of Oracle's storage hierarchy from smallest to largest?

Segment, extent, database block, operating-system block

Operating-system block, database block, extent, segment

Operating-system block, segment, extent, database block

Database block, operating-system block, extent, segment

Question 2: What happens when the PMON process is terminated in Oracle Database?

Oracle spawns another PMON process automatically

The database hangs and the DBA must manually start the PMON process

The database crashes and must be restarted

PMON is not critical, and the instance continues running

Question 3: When a user commits a transaction, which background process is responsible for writing the transaction details to the redo log files?

DBWn

LGWR

CKPT

SMON

Question 4: Which of the following startup modes is used when creating a new database?

STARTUP FORCE

STARTUP MOUNT

STARTUP RESTRICT

STARTUP NOMOUNT

Question 5: Which process is responsible for performing instance recovery after a database crash?

LGWR

SMON

CKPT

PMON

Question 6: In Oracle RAC, which statement best describes a RAC configuration?

One database, multiple instances

One instance, multiple databases

Multiple databases on different servers

Multiple databases, multiple instances

Question 7: Which component of the SGA stores parsed SQL statements?

Database buffer cache

Redo log buffer

Library cache

Large pool

Question 8: Which of the following processes cleans up after a user session is terminated?

SMON

PMON

DBWn

CKPT

Question 9: Which background process writes the dirty blocks from the database buffer cache to the data files?

DBWn

LGWR

SMON

CKPT

Question 10: Which of the following SGA components would you increase to ensure that RMAN tape backups do not use memory from the shared pool?

Large pool

Java pool

Streams pool

Redo log buffer

Question 11: Which startup mode would be used to allow only DBA users to connect to the database?

STARTUP FORCE

STARTUP RESTRICT

STARTUP NOMOUNT

STARTUP MOUNT

Question 12: Which of the following components is part of the Oracle database, not the Oracle instance?

System Global Area (SGA)

Control file

Process monitor

Shared pool

Question 13: Which data dictionary view would you query to find the current status of redo log groups?

V$REDOLOG

V$LOGFILE

V$LOG

V$DATABASE

Question 14: Which Oracle file is updated with the checkpoint position during an incremental checkpoint?

Control file

Data files

Redo log files

Parameter files

Question 15: Which background process is responsible for writing the checkpoint information to the control files?

LGWR

CKPT

SMON

DBWn

Question 16: Which component of the Oracle database architecture includes the system global area (SGa) and background processes?

Oracle database

Oracle instance

Oracle schema

Oracle segment

Question 17: In which file can you find information on Oracle database errors such as ORA-00600?

Listener log

Data files

Control files

Alert log

Question 18: Which background process is responsible for archiving redo logs in ARCHIVELOG mode?

DBWn

ARCn

SMON

PMON

Question 19: Which of the following SQL statements will show the redo log groups required for instance crash recovery?

SELECT GROUP# FROM V$REDOLOG;

SELECT GROUP#, STATUS FROM V$LOG;

SELECT * FROM V$LOGFILE;

SELECT * FROM V$ARCHIVED_LOG;

Question 20: What is the primary purpose of the data dictionary in an Oracle database?

Store user data

Store metadata about database objects

Store redo log information

Store configuration parameters

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