Oracle Database Administrator Practice Test

1. Which parameter defines the location of Oracle database files in the initialization file?

DB_NAME

DB_FILES

DB_FILE_MULTIBLOCK_READ_COUNT

DB_RECOVERY_FILE_DEST

2. What is the primary purpose of the alert log in Oracle database?

Store user login credentials

Record database errors, warnings, and significant events

Track application performance metrics

Maintain backup file inventory

3. Which command is used to create a backup of the entire database in NOARCHIVELOG mode?

RMAN BACKUP DATABASE

ALTER DATABASE BACKUP CONTROLFILE

SHUTDOWN IMMEDIATE followed by OS file copy

EXP FULL=Y

Submit

5. What does LGWR (Log Writer) process do in Oracle?

Writes redo log entries from memory to disk

Reads data blocks from datafiles

Manages user session connections

Performs checkpoint operations

6. Which view displays information about all tablespaces in the database?

DBA_DATAFILES

DBA_TABLESPACES

DBA_SEGMENTS

DBA_EXTENTS

Submit

8. Which initialization parameter determines the number of database writer processes?

DB_WRITERS

DBW0_PROCESSES

DB_WRITER_PROCESSES

PARALLEL_WRITERS

9. True or False: In ARCHIVELOG mode, the database can be recovered to any point in time using archived logs.

True

False

10. What is the primary function of the SMON (System Monitor) process?

Manages user session memory

Performs instance recovery and cleans temporary segments

Writes modified data blocks to disk

Archives redo log files

Submit

12. Which command enables archiving of redo logs in Oracle?

ALTER DATABASE ARCHIVELOG

ALTER SYSTEM ARCHIVELOG ON

STARTUP ARCHIVELOG

ALTER DATABASE ENABLE ARCHIVING

13. True or False: The SGA (System Global Area) is allocated at database startup and is shared by all processes.

True

False

14. Which Oracle utility is used to export database objects and data to a binary file?

SQL*Loader

Data Pump Export (expdp)

RMAN

SQL*Plus

Submit

Oracle Database Administrator Practice Test

1. Which parameter defines the location of Oracle database files in the initialization file?

2.

What first name or nickname would you like us to use?

2. What is the primary purpose of the alert log in Oracle database?

3. Which command is used to create a backup of the entire database in NOARCHIVELOG mode?

4. In Oracle, the ______ is the smallest unit of space allocation within a tablespace.

5. What does LGWR (Log Writer) process do in Oracle?

6. Which view displays information about all tablespaces in the database?

7. The ______ is a special file that contains information about the physical structure of the database.

8. Which initialization parameter determines the number of database writer processes?

9. True or False: In ARCHIVELOG mode, the database can be recovered to any point in time using archived logs.

10. What is the primary function of the SMON (System Monitor) process?

11. The ______ clause is used in RMAN to specify which database files to include in a backup.

12. Which command enables archiving of redo logs in Oracle?

13. True or False: The SGA (System Global Area) is allocated at database startup and is shared by all processes.

14. Which Oracle utility is used to export database objects and data to a binary file?

15. The ______ parameter specifies the maximum number of processes that can connect to an Oracle instance.