If your columns are indexed, what clause would you run for the RUNSTATS command to collect statistics?

Given the following code: EXEC SQL EXECUTE IMMEDIATE: sqlstmt Which of the following values must sqlstmt contain so that all rows are deleted from the STAFF table?

Which action will occur when issuing the command FORCE APPLICATION ALL?

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

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

What is one way that a query might be rewritten?

Which of the following DSNZPARMs is necessary to influence access path selection for certain queries?

Given the following statement: CREATE TABLESPACE smt1 MANAGED BY DATABASE USING (FILE 'smt01' 1024K) How many pages will be created for the table space?

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?

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

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?