Oracle DBA Security and Auditing Quiz

1. What is the primary purpose of the AUDIT command in Oracle Database?

To compress database logs

To track user actions and database events

To encrypt sensitive data

To manage backup operations

2. The AUDIT ALL command by default audits which statement types?

DDL, DML, and DCL statements

Only DDL statements

Only DML statements

Query statements only

3. The DBA_AUDIT_TRAIL view contains audit records for which activities?

Only DDL statements

Only DML statements

All audited database activities

Only login failures

4. What does Transparent Data Encryption (TDE) protect?

Network traffic only

Data at rest in tablespaces

User passwords only

Backup files only

5. Which initialization parameter specifies the location for unified audit trail records?

AUDIT_FILE_DEST

DB_RECOVERY_FILE_DEST

AUDIT_UNIFIED_DEST

LOG_ARCHIVE_DEST_1

6. Oracle's Database Vault protects against which type of threat?

Network attacks only

Unauthorized data access by privileged users

Password guessing only

Backup corruption only

7. Which parameter must be set to enable database auditing?

AUDIT_TRAIL=NONE

AUDIT_TRAIL=DB or higher

ENABLE_AUDIT=TRUE

AUDIT_MODE=ON

8. Which command disables all auditing for a specific user's SELECT statements?

NOAUDIT SELECT BY username;

DISABLE AUDIT SELECT BY username;

STOP AUDIT SELECT BY username;

REMOVE AUDIT SELECT BY username;

9. Which audit option records all SELECT statements issued by a specific user?

AUDIT SELECT BY username;

AUDIT SELECT ON username;

AUDIT ALL BY username;

AUDIT SELECT FOR username;

10. The IDENTIFIED BY EXTERNAL clause is used for which authentication method?

Database password authentication

Operating system authentication

LDAP authentication

Kerberos authentication

11. Which view displays the privileges granted directly to a specific user?

DBA_ROLE_PRIVS

DBA_SYS_PRIVS

USER_SYS_PRIVS

DBA_TAB_PRIVS

12. What does the UNIFIED_AUDIT_TRAIL view provide compared to traditional audit views?

Faster query performance only

Consolidated audit data from database and OS

Only DML audit records

Real-time alerts only

13. Oracle Virtual Private Database (VPD) uses which mechanism to enforce security?

Firewall rules

Dynamic WHERE clause predicates

Operating system permissions

Network encryption

14. Oracle Label Security (OLS) uses which mechanism to control data access?

Role-based access control

Sensitivity labels and clearances

IP address restrictions

Time-based restrictions

15. Which privilege allows a user to grant privileges to other users?

ADMIN OPTION

WITH ADMIN OPTION

GRANT OPTION

WITH GRANT OPTION

16. The CREATE USER statement with IDENTIFIED BY GLOBALLY AS 'DN' enables which authentication?

Database authentication

X.509 certificate authentication

Operating system authentication

Radius authentication

17. Which privilege is required to view other users' audit records in DBA_AUDIT_TRAIL?

SELECT ANY TABLE

AUDIT SYSTEM

AUDIT ADMIN

SELECT on DBA_AUDIT_TRAIL

18. Which parameter controls the retention period for audit records in the AUD$ table?

AUDIT_TRAIL_DEST_FILENAME

AUDIT_SYS_OPERATIONS

DB_RECOVERY_FILE_DEST

AUDIT_TRAIL

19. Which system privilege allows a user to create tables in their own schema?

CREATE ANY TABLE

CREATE TABLE

ALTER TABLE

DROP ANY TABLE

20. Which Oracle authentication method uses a password file stored outside the database?

Database authentication

Operating system authentication

Password file authentication

LDAP authentication

Oracle DBA Professional Database Security and Auditing Quiz

1. What is the primary purpose of the AUDIT command in Oracle Database?

2.

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

2. The AUDIT ALL command by default audits which statement types?

3. The DBA_AUDIT_TRAIL view contains audit records for which activities?

4. What does Transparent Data Encryption (TDE) protect?

5. Which initialization parameter specifies the location for unified audit trail records?

6. Oracle's Database Vault protects against which type of threat?

7. Which parameter must be set to enable database auditing?

8. Which command disables all auditing for a specific user's SELECT statements?

9. Which audit option records all SELECT statements issued by a specific user?

10. The IDENTIFIED BY EXTERNAL clause is used for which authentication method?

11. Which view displays the privileges granted directly to a specific user?

12. What does the UNIFIED_AUDIT_TRAIL view provide compared to traditional audit views?

13. Oracle Virtual Private Database (VPD) uses which mechanism to enforce security?

14. Oracle Label Security (OLS) uses which mechanism to control data access?

15. Which privilege allows a user to grant privileges to other users?

16. The CREATE USER statement with IDENTIFIED BY GLOBALLY AS 'DN' enables which authentication?

17. Which privilege is required to view other users' audit records in DBA_AUDIT_TRAIL?

18. Which parameter controls the retention period for audit records in the AUD$ table?

19. Which system privilege allows a user to create tables in their own schema?

20. Which Oracle authentication method uses a password file stored outside the database?