Oracle DBA Security and Auditing Quiz

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

DBA_ROLE_PRIVS

DBA_SYS_PRIVS

USER_SYS_PRIVS

DBA_TAB_PRIVS

2. 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

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

DDL, DML, and DCL statements

Only DDL statements

Only DML statements

Query statements only

4. 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

5. 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

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

Database authentication

X.509 certificate authentication

Operating system authentication

Radius authentication

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. 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

9. 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;

10. 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

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

Database authentication

Operating system authentication

Password file authentication

LDAP authentication

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

Database password authentication

Operating system authentication

LDAP authentication

Kerberos authentication

13. 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;

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

Firewall rules

Dynamic WHERE clause predicates

Operating system permissions

Network encryption

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

ADMIN OPTION

WITH ADMIN OPTION

GRANT OPTION

WITH GRANT OPTION

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

Network traffic only

Data at rest in tablespaces

User passwords only

Backup files only

17. 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

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

Only DDL statements

Only DML statements

All audited database activities

Only login failures

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. 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

Oracle DBA Professional Database Security and Auditing Quiz

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

2.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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