Which of the following are contained in the PLAN_TABLE? (Choose two.)

A. RUNSTATS recommendations

B. Access to LOB values, which are stored separately from the base table

C. Access to parent or dependent tables needed to enforce referential constraints

D. Whether an index access or table space scan is used for each access to a table

E. The join methods and types that are used, and the order in which DB2 joins the tables

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

Given the following table and index definitions, what type of index will be created?

A. Non-partitioned index

B. Non-partitioned secondary index

C. Data-partitioned secondary index

D. Data-partitioned partitioning index

In order to run a DB2 program, the user issues the following commands:

TSO prompt: READY

USER enters: DSN SYS(SSTR)

USER enters: RUN PROGRAM(MYPROG)

USER enters: END

What is the result?

A. DB2 does not allow these commands

B. DSN command can not be used to run a program

C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

D. Start a DSN session with system parameters SSTR, run a program and end the DSN session

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;

Which of the following is NOT a valid lock size in DB2?

A. Table

B. Partition

C. Database

D. Table space

The following warning message is issued when the last available active log data set is 5% full:

DSNJ110E -LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL

What will happen if you ignore this message?

A. DB2 will shut down if it reaches the 100% full condition

B. DB2 will overwrite the oldest archive log without archiving

C. DB2 will stop any activity that requires log writes if it reaches the 100% full condition

D. DB2 will automatically allocate more active log data sets as long as there are still less than 93 of them

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

A. BLOB

B. CLOB

C. DBCLOB

D. VARGRAPHIC

Given the following sequence of events:

1) COL1 in SCHEMA.TABLE has a value of 10 2)Update COL1 in SCHEMA.TABLE to 20 3) Set SAVEPOINT A 4) Update COL1 in SCHEMA.TABLE to 30 5) Set SAVEPOINT B After issuing the statement: ROLLBACK TO SAVEPOINT

What will be the value in COL1 of the SCHEMA.TABLE?

A. 10

B. 20

C. 30

D. An -880 SQLCODE will be issued when the statement is executed

Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?

A. SYSIBM.SYSCHECKDEP

B. SYSIBM.SYSPENDINGDDL

C. SYSIBM.SYSDEPENDENCIES

D. SYSIBM.SYSPENDINGOBJECTS