Database Auditing and Access Logs Quiz

1. Which mechanism prevents unauthorized users from accessing sensitive database objects?

Access Control Lists (ACLs)

Query optimization

Database compression

Backup scheduling

Submit

3. What is the benefit of real-time audit monitoring?

Immediate detection and response to security incidents

Reduction in database file size

Improved user login speed

Automatic query optimization

4. True or False: Privilege escalation attempts should trigger immediate alerts in audit systems.

True

False

Submit

6. Which of these is a critical component of data governance for audit logs?

Defining retention policies and access controls

Deleting logs after 24 hours

Storing logs on external USB drives

Sharing logs with all employees

7. What does multi-factor authentication (MFA) add to database access control?

An additional security layer requiring multiple verification methods

Faster query processing

Lower storage requirements

Automatic database backups

8. True or False: Failed login attempts should be recorded in access logs.

True

False

Submit

10. What is the purpose of encrypting audit logs?

To protect log integrity and prevent tampering

To speed up log file access

To reduce audit log size

To improve database performance

11. What is the primary purpose of database auditing?

To increase database performance

To track and record user activities and data modifications

To reduce storage costs

To improve query execution speed

12. True or False: Audit logs should be regularly reviewed for suspicious activity.

True

False

Submit

14. Database audit logs typically record what information about a query?

User identity, timestamp, query text, and affected tables

Only the database server name

Query execution plan only

Hardware specifications

15. What does the principle of least privilege mean in database security?

Users receive only the minimum permissions needed for their role

All users have identical access levels

Administrators have unrestricted access

Permissions are granted permanently without review

16. Which access control model grants permissions based on user identity and defined policies?

Discretionary Access Control (DAC)

Mandatory Access Control (MAC)

Role-Based Access Control (RBAC)

Attribute-Based Access Control (ABAC)

17. True or False: Database audit logs should be stored in the same database they monitor.

True

False

Submit

19. What is a timestamp in database audit logs used for?

To identify when specific events occurred

To encrypt sensitive data

To compress log files

To prioritize user requests

20. Which of the following should be logged in database access logs?

User login attempts, queries executed, and data modifications

Only successful login attempts

Database server uptime only

Network traffic patterns

DataSys+ Database Auditing and Access Logs Quiz

1. Which mechanism prevents unauthorized users from accessing sensitive database objects?

2.

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

2. Database administrators should regularly review access logs to identify ____.

3. What is the benefit of real-time audit monitoring?

4. True or False: Privilege escalation attempts should trigger immediate alerts in audit systems.

5. Compliance frameworks like HIPAA and GDPR require organizations to maintain ____.

6. Which of these is a critical component of data governance for audit logs?

7. What does multi-factor authentication (MFA) add to database access control?

8. True or False: Failed login attempts should be recorded in access logs.

9. Database access logs help detect ____.

10. What is the purpose of encrypting audit logs?

11. What is the primary purpose of database auditing?

12. True or False: Audit logs should be regularly reviewed for suspicious activity.

13. An audit trail is a chronological record of ____.

14. Database audit logs typically record what information about a query?

15. What does the principle of least privilege mean in database security?

16. Which access control model grants permissions based on user identity and defined policies?

17. True or False: Database audit logs should be stored in the same database they monitor.

18. Role-based access control (RBAC) restricts database access based on ____.

19. What is a timestamp in database audit logs used for?

20. Which of the following should be logged in database access logs?