IBM Db2 Database Security Quiz

1. In Db2, the SYSADM authority provides which level of control?

Read-only access to tables

Administrative control over the entire database system

Limited schema modifications

Query execution only

2. True or False: Db2 audit logs can be encrypted to protect audit trail integrity.

True

False

3. Which Db2 feature enforces password complexity and expiration policies?

Password Manager

Security Policy

User Authentication Profile

Connection String

4. True or False: In Db2, implicit privileges are automatically granted to all users for accessing public schemas.

True

False

5. What does the DBADM authority in Db2 allow a user to do?

Only execute SELECT queries

Manage database objects and perform administrative tasks

Read-only access to system catalogs

Modify operating system files

6. In Db2, which audit policy level records schema changes and privilege modifications?

AUDIT_ALL

AUDIT_ADMIN

AUDIT_BASIC

AUDIT_NONE

7. True or False: Db2 supports multi-factor authentication for enhanced user security.

True

False

8. What is the primary function of the Db2 security label component?

To classify and control access to sensitive data

To optimize query execution

To manage memory allocation

To schedule maintenance tasks

9. Which Db2 security feature allows masking of sensitive data in query results?

Data Masking

Query Caching

Index Partitioning

Buffer Management

10. True or False: Transparent Data Encryption (TDE) in Db2 encrypts data automatically without application changes.

True

False

11. Which authentication method in IBM Db2 allows users to authenticate using external directory services like LDAP?

SERVER_ENCRYPT

LDAP authentication

LOCAL authentication

KERBEROS only

12. What is the purpose of row-level security (RLS) in Db2?

To filter query results based on user identity

To prevent table creation

To improve query performance

To manage backup retention

13. Which command revokes privileges from a user in Db2?

REVOKE

DENY

REMOVE

DELETE

14. True or False: Column-level security in Db2 can restrict which columns specific users can access.

True

False

15. In Db2, what does the GRANT statement do?

Removes user access to database objects

Assigns privileges to users or roles

Encrypts sensitive data

Creates backup copies

16. Which Db2 audit facility records all database access and modifications?

Query Optimizer

Audit Log

Transaction Manager

Buffer Pool

17. What encryption standard does IBM Db2 support for data in transit?

SSL/TLS

MD5 only

Base64 encoding

ROT13

18. True or False: In Db2, the PUBLIC role can execute all administrative commands by default.

True

False

19. Which Db2 privilege allows a user to modify table structures and indexes?

SELECTIN

ALTERIN

ALTER privilege

CREATEIN

20. What is the primary purpose of role-based access control (RBAC) in Db2?

To encrypt all database connections

To assign permissions based on user job responsibilities

To monitor query performance

To create backup schedules

IBM Db2 Database Security Quiz

1. In Db2, the SYSADM authority provides which level of control?

2.

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

2. True or False: Db2 audit logs can be encrypted to protect audit trail integrity.

3. Which Db2 feature enforces password complexity and expiration policies?

4. True or False: In Db2, implicit privileges are automatically granted to all users for accessing public schemas.

5. What does the DBADM authority in Db2 allow a user to do?

6. In Db2, which audit policy level records schema changes and privilege modifications?

7. True or False: Db2 supports multi-factor authentication for enhanced user security.

8. What is the primary function of the Db2 security label component?

9. Which Db2 security feature allows masking of sensitive data in query results?

10. True or False: Transparent Data Encryption (TDE) in Db2 encrypts data automatically without application changes.

11. Which authentication method in IBM Db2 allows users to authenticate using external directory services like LDAP?

12. What is the purpose of row-level security (RLS) in Db2?

13. Which command revokes privileges from a user in Db2?

14. True or False: Column-level security in Db2 can restrict which columns specific users can access.

15. In Db2, what does the GRANT statement do?

16. Which Db2 audit facility records all database access and modifications?

17. What encryption standard does IBM Db2 support for data in transit?

18. True or False: In Db2, the PUBLIC role can execute all administrative commands by default.

19. Which Db2 privilege allows a user to modify table structures and indexes?

20. What is the primary purpose of role-based access control (RBAC) in Db2?