Practice questions

Question 1: Which statement about the SERVER_ENCRYPT authentication setting is true?

1. The user ID and password will be encrypted
2. The user ID will be encrypted
3. The user ID, password, and data will be encrypted
4. The password will be encrypted

Question 2: Which special register is valid in the VERIFY_TRUSTED_CONTEXT_ROLE_FOR_USER built-in function?

1. CURRENT_USER
2. SESSION_USER
3. SYSTEM_USER
4. GROUP_USER

Question 3: Which of these parameters are essential in setting up native encryption? (Choose two.)

1. KMIP_TYPE
2. KEYSTORE_LOCATION
3. KEY_HASH_TYPE
4. KEYSTORE_TYPE
5. KEYSTORE_HOSTNAME

Question 4: Which of the following is NOT a security table function?

1. SYSIBMADM.PRIVILEGES
2. AUTH_LIST_AUTHORITIES_FOR_AUTHID
3. AUTH_LIST_GROUPS_FOR_AUTHID
4. AUTH_LIST_ROLES_FOR_AUTHID

Question 5: Which authorities can be audited with the Db2 AUDIT statement?

1. SECADM, DBADM, SYSMAINT, and SYSCTRL can...