Oracle - Database Administration MCQ

Oracle – Database Administration

1 / 25

1. What is the primary role of a Database Administrator (DBin Oracle?

Writing SQL queries

Developing applications

Managing hardware resources

Ensuring database availability and performance

2 / 25

2. Which tool is commonly used for Oracle database administration tasks, such as backup and recovery?

Toad

Oracle Enterprise Manager (OEM)

SQL*Plus

SQL Developer

3 / 25

3. In Oracle, what is the purpose of the Control File?

Store user data

Perform backups

Manage database structures and transactions

Manage table definitions

4 / 25

4. Which Oracle background process is responsible for writing committed data to the database’s data files?

LGWR (Log Writer)

PMON (Process Monitor)

SMON (System Monitor)

DBWR (Database Writer)

5 / 25

5. What is the purpose of the redo log files in Oracle?

Store user data

Record changes made to the database

Store backup data

Manage user access

6 / 25

6. Which database role in Oracle is responsible for creating and managing user accounts?

DBA

DB_OWNER

SYSOPER

SYSDBA

7 / 25

7. In Oracle, what is the role of the SYSTEM tablespace?

Store user data

Store system metadata and data dictionary information

Manage backups

Store temporary data

8 / 25

8. What is the purpose of the Oracle Data Dictionary?

Manage database security

Store system metadata and information about database objects

Manage user accounts

Store user data

9 / 25

9. Which Oracle background process is responsible for cleaning up after failed transactions and releasing locks?

DBWR (Database Writer)

PMON (Process Monitor)

LGWR (Log Writer)

SMON (System Monitor)

10 / 25

10. Which Oracle background process is responsible for managing the physical database structures?

PMON (Process Monitor)

SMON (System Monitor)

LGWR (Log Writer)

DBWR (Database Writer)

11 / 25

11. What is the purpose of the PGA (Program Global Arein Oracle?

Manage system tables

Manage database backups

Store user data

Store SQL statements

12 / 25

12. Which statement is true about the SYSTEM user in Oracle?

It has limited privileges compared to other users.

It is a regular user account.

It is automatically created during database installation.

It can be deleted by the DBA.

13 / 25

13. What is the purpose of the Oracle Listener?

Manage database backups

Control network connections to the database

Create database objects

Execute SQL statements

14 / 25

14. In Oracle, what is the role of the TEMP tablespace?

Store permanent user data

Manage user accounts

Create database triggers

Store temporary data for sorting and processing

15 / 25

15. What is the purpose of the Oracle SQL*Plus tool?

Create database objects

Execute SQL statements

Develop applications

Perform database administration tasks

16 / 25

16. Which statement is true about the SYSTEM and SYS users in Oracle?

They have the same privileges and roles.

The SYSTEM user has more privileges than the SYS user.

Both users are regular user accounts.

The SYS user is created automatically during database installation.

17 / 25

17. Which Oracle background process is responsible for managing and coordinating parallel execution of queries?

PMON (Process Monitor)

PARALLEL_EXEC

SMON (System Monitor)

LGWR (Log Writer)

18 / 25

18. What is the primary responsibility of the DBA role in Oracle?

Managing database objects and users

Writing SQL queries

Hardware maintenance

Developing applications

19 / 25

19. In Oracle, what is the role of the redo log buffer?

Store committed changes temporarily before writing to redo log files

Store user data

Store SQL statements

Manage database security

20 / 25

20. What is the purpose of the Oracle Automatic Storage Management (ASM)?

Manage database backups

Simplify storage management for Oracle databases

Manage user accounts

Manage hardware resources

21 / 25

21. Which Oracle background process is responsible for managing database security by authenticating users and authorizing their access?

PMON (Process Monitor)

LGWR (Log Writer)

SMON (System Monitor)

DBWR (Database Writer)

22 / 25

22. In Oracle, what is the SYSTEM_PRIVILEGE role used for?

Executing SQL statements

Managing user accounts

Managing system tables

Assigning system privileges to users

23 / 25

23. What is the primary purpose of the Oracle Automatic Diagnostic Repository (ADR)?

Store backup data

Store user data

Store diagnostic information and logs

Store system metadata

24 / 25

24. Which Oracle background process is responsible for managing distributed transactions?

DBWR (Database Writer)

SMON (System Monitor)

PMON (Process Monitor)

LGWR (Log Writer)

25 / 25

25. What is the purpose of the Oracle RMAN (Recovery Manager) tool?

Create database triggers

Execute SQL statements

Manage database backups and recovery

Manage database objects

Your score is

Oracle – Database Administration MCQ