Database Administration & Security Flashcards

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

Answer: Oracle Enterprise Manager (OEM)

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

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

Answer: CREATE SESSION

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

What is the purpose of the Oracle AUDIT statement?

Answer: To track user actions and database events for security purposes

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

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

Answer: DBA_ROLE_PRIVS

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

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

Answer: DBWR

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

What happens to a user's objects when the user account is DROPPED in Oracle?

Answer: All objects owned by the user are also dropped

Dropping a user with the CASCADE option removes the user and all their schema objects from the database.

Which SQL statement is used to change a user's password in Oracle?

Answer: ALTER USER ... IDENTIFIED BY

The ALTER USER statement with the IDENTIFIED BY clause is used to change a user's password in Oracle.