1Z0-006 Database Administration & Security 2

Question 1

Which Oracle tool provides a graphical interface for database administration tasks such as managing users and monitoring performance?

Accepted Answer

Oracle Enterprise Manager (OEM)

Answer

Oracle Enterprise Manager provides a browser-based GUI for comprehensive database administration and monitoring.

Question 2

Which privilege allows a user to log in to the Oracle database?

Accepted Answer

CREATE SESSION

Answer

The CREATE SESSION system privilege is required for a user to establish a connection to the Oracle database.

Question 3

What is the purpose of the Oracle AUDIT statement?

Accepted Answer

To track user actions and database events for security purposes

Answer

The AUDIT statement enables auditing of specified actions so DBAs can track who performed what operations in the database.

Question 4

Which data dictionary view shows all roles granted to a specific database user?

Accepted Answer

DBA_ROLE_PRIVS

Answer

DBA_ROLE_PRIVS lists all roles granted to users and other roles in the database.

Question 5

Which Oracle background process writes dirty buffers from the database buffer cache to data files?

Accepted Answer

DBWR

Answer

DBWR (Database Writer) is responsible for writing modified (dirty) data blocks from the buffer cache to the data files on disk.

(1Z0-006) Oracle Database Foundations Associate Practice Test