IBM DB2 10.1 Fundamentals

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

A table named EMPLOYEE was created as follows: Which action will prevent unauthorized users from accessing SSN data?

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

Which privilege is required to invoke a user defined function?

Which statement is true about an index that is used to support a UNIQUE constraint?

Which statement regarding triggers is true?

A table named STATES was created as follows: What will happen?

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?