1.
If the following statement is executed: What occurs if user USER2 connects from the IP address 10.10.10.10 where the database is cataloged with SERVER_ENCRYPT?
2.
Which SQL statement will archive the audit log for the connected database?
3.
User USER1 is a member of the SYSADM group for instance INST1 in DB2 9.7. Database DB_1 was just created within INST1 by user USER2. What additional authorities must be directly granted to USER1 in order for USER1 to retain the same privileges they would have had if database DB_1 had been created with DB2 9.5 by USER2?
4.
Which function/stored procedure CANNOT be used to view audit facility data?
5.
Which DB2 9.7 database authority can be granted to the group PUBLIC?
6.
A DBA sets the AUTO_DEL_REC_OBJ database configuration parameter to ON. When the PRUNE HISTORY command is executed with the AND DELETE option specified, what will occur?
7.
Which tool can be used to configure High Availability and Disaster Recovery (HADR) in a clustered environment?
8.
When using an online backup recovery strategy, what steps are required to backup and recover a database to the end of backup timestamp?
9.
What is the correct setting for the DIAGSIZE database manager configuration parameter to limit the total size of the db2diag.log and .nfy files to 60 MB and use 10 rotating files for db2diag.log and 10 for .nfy?
10.
A DB2 9.7 database has been enabled for Oracle compatibility. What is the command to disable all compatibility features?