Which of the following explicit system privileges allows the user to create new plans and packages without being able to also execute them?

What parameter and option must be set before using a DB2 DBMS?

Which of the following RACF profiles would be used to allow IMS to access DB2 DSN1?

To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?

What does it mean if the the null indicator = -1

Given the following DDL statements: CREATE TABLE person OF person_t (REF IS OID USER GENERATED) CREATE TABLE emp OF emp_t UNDER person INHERIT SELECT PRIVILEGES CREATE TABLE student OF student_t UNDER person INHERIT SELECT PRIVILEGES Which of the following will drop all tables associated with the hierarchy?

A DBA needs to use the DSN command processor to delete DB2 packages that are no longer needed. Which of the following choices is correct for the DBA to use?

What type of parameter is “dbheap”?

What is one way that a query might be rewritten?

To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?

Which tool can be used to edit related backup tasks created in the Task Center