2. Which is the command to start the instance?
C. db2start

3. If a user has ALTER privilege for a table, which task can they perform?
C. Drop a primary key definition

4. What is the relationship between DB2 instances and databases?
C. The authentication for the database and its instance must match

5. Which authority or privilege is specified in the DBM configuration?
C. SYSADM

6. Given the following users :
USER1 needs to be able to backup databases, USER2 needs to be able to monitor database activity
If USER1 and USER2 belong to GROUPA, which task is required to setup these users?
A. Add their userids to the SYSADM group, as specified in the DBM configuration

7. Where would you look to determine which users had the ability to create a table?
C. SYSCAT.DBAUTH

8. Which statement defines table check constraints?
B. CREATE TABLE

9. What action can result in internal record deletes?
C. referential integrity constraints

10. Given the tables:
PC
serial_num INT
model_num INT
owner_id INT

EMPLOYEE
employee_num INT NOT NULL PRIMARY KEY
Which action ensures that no rows can be inserted into the PC table unless the owner_id matches an employee_num value in the EMPLOYEE table?
C. Add a foreign key constraint to the PC table

11. Which action will cause an index to be created?
C. Define a primary key constraint

12. Which isolation level would lock the most data?
C. repeatable read

13. Which table space characteristic can be altered for a DMS table space?
B. Modify the prefetch size

14. Which of the following can be used as a container in an SMS table space?
C. Directory

15. Why might data exist in the exception table following a LOAD operation?
A. Primary key constraint violations

16. What command would update the database recovery history file?
C. BACKUP

17. When is the table space recovery available?
C. When log retain is enabled

18. Which command should you use to update a package after the developer has modified the application executable?
B. BIND

19. What must be done prior to capturing an EXPLAIN snapshot?
C. Create the EXPLAIN tables

20. There are two tables defined in a database called: db2.staff and payroll.staff
An application issues a dynamic SQL statement "SELECT * FROM staff". What determines which table will be accessed?
B. the userid connected to the database