1.
Which category is used to audit the running of SQL statements?
2.
What authority is required to grant SECADM authority to roles and groups?
3.
Given the following GRANT commands: Assuming that user BOB belongs to the group STAFF and STAFF has no other privileges aside from what is defined above, what is the highest level of privilege that BOB has on the database?
4.
Which SQL statement must be executed in order to give a user named USER1 the ability to query the system catalog tables and views?
5.
What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SSL) support?
6.
Which command will enable Oracle applications to work within a DB2 9.7 environment?
7.
When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?
8.
Which statement describes the state of the DMS table space TBS_1 after the successful execution of the following script? ALTER TABLESPACE tbs_1 MANAGED BY AUTOMATIC STORAGE
9.
After executing the following statement: ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK What is the expected result?
10.
A database administrator wants to load XML data into the table DB2USER.T1 from the delimited ASCII file /home/user/xml/data1.del. Which command will load the XML data and validate it against a XML schema?