1Z0-006 Database Administration & Security 2 — Questions and Answers
Question 1: Which Oracle tool provides a graphical interface for database administration tasks such as managing users and monitoring performance?
- SQL*Loader
- Oracle Enterprise Manager (OEM) (Correct answer)
- RMAN
- Data Pump
Correct answer: Oracle Enterprise Manager (OEM)
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?
- CREATE SESSION (Correct answer)
- CREATE TABLE
- CONNECT
- DBA
Correct answer: CREATE SESSION
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?
- To back up the database
- To track user actions and database events for security purposes (Correct answer)
- To optimize SQL queries
- To grant object privileges
Correct 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.
Question 4: Which data dictionary view shows all roles granted to a specific database user?
- DBA_SYS_PRIVS
- DBA_ROLE_PRIVS (Correct answer)
- DBA_TAB_PRIVS
- USER_ROLES
Correct answer: DBA_ROLE_PRIVS
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?
- LGWR
- DBWR (Correct answer)
- SMON
- PMON
Correct answer: DBWR
DBWR (Database Writer) is responsible for writing modified (dirty) data blocks from the buffer cache to the data files on disk.
Question 6: What happens to a user's objects when the user account is DROPPED in Oracle?
- Objects are moved to the SYSTEM schema
- Objects are retained but become inaccessible
- All objects owned by the user are also dropped (Correct answer)
- Objects are archived to a backup tablespace
Correct 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.
Question 7: Which SQL statement is used to change a user's password in Oracle?
- MODIFY USER ... PASSWORD
- UPDATE USER ... SET PASSWORD
- ALTER USER ... IDENTIFIED BY (Correct answer)
- CHANGE PASSWORD FOR ...
Correct answer: ALTER USER ... IDENTIFIED BY
The ALTER USER statement with the IDENTIFIED BY clause is used to change a user's password in Oracle.
1Z0-006 Database Administration & Security 2
Which Oracle tool provides a graphical interface for database administration tasks such as managing users and monitoring performance?