The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

A. A view

B. A temporal table

C. A created global temporary table

D. A declared global temporary table

If a scrollable cursor is INSENSITIVE, which of the following applies?

A. The cursor is read only

B. WITH ROWSET POSITIONING is not allowed

C. The select-statement must not contain an SQL data change statement

D. The cursor has sensitivity to changes that are made to the database after the result table is materialized

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

A. GRANT, COPY, BIND, RUN

B. BIND, EXECUTE, COPY, RUN

C. CREATE, COPY, RUN, EXECUTE

D. COPY, BINDADD, SQL, EXECUTE

Which of the following are valid objects created using DDL? (Choose two.)

A. PLAN

B. PACKAGE

C. DATABASE

D. SEQUENCE

E. USAGE LISTS

Which of the following SELECT statements returns a different data value than the other SQL statements?

A. SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

B. SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

C. SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENT TIMESTAMP(10)),6,2),'0'),11,'') FROM SYSIBM.SYSDUMMY1;

D. SELECT TIMESTAMPDIFF(64, CHAR(CURRENT TIMESTAMP ?TIMESTAMP(`2016-01-0100.00.00'))) FROM SYSIBM.SYSDUMMY1;

To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table. If DB2 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

A. CHECK PENDING

B. REORG PENDING

C. REBUILD PENDING

D. ADVISORY REORG PENDING

Which of the following utilities or utility control statements require datasets for execution?

A. LISTDEF

B. OPTIONS

C. TEMPLATE

D. CHECK LOB

A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT is allowed).

Which BIND parameter setting can you use to accomplish this?

A. DYNAMICRULES(RUN)

B. DYNAMICRULES(BIND)

C. DYNAMICRULES(INVOKERUN)

D. DYNAMICRULES(DEFINEBIND)

Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

A. SYSIBM.SYSSTMT

B. SYSIBM.SYSPARMS

C. SYSIBM.SYSROUTINES

D. SYSIBM.SYSVARIABLES

Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)

A. MAXPARTITIONS

B. ENDING AT clause on a CREATE INDEX statement for the table

C. MEMBER CLUSTER

D. ENDING AT clause on the CREATE TABLE statement

E. A LOB column specified as a column of the partitioning key