In a client-server environment, which two of the following can be used to verify passwords?

A table named DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY
Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

Which authority or privilege is granted by the DB2 Database Manager configuration file?

Which two of the following authorities allow a user to create a new database?

Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to
create a view named VIEW1 that references two tables named TAB1 and TAB2?

Which of the following will allow user USER1 to change the comment associated with a table
named TABLE1?

A table called DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME
column?

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow
user USER1 to drop the EMPID_X index?

On which two of the following database objects may the SELECT privilege be controlled?

User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no
authorities or privileges, which of the following privileges are needed?