Which of the following elements is affected by a ROLLBACK statement?

A. LOB table spaces

B. Changes in cursor positioning

C. Acquisition and release of locks

D. Caching of rolled back statements

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

A. TRUNCATE employee;

B. DELETE FROM employee;

C. DELETE FROM employee WHERE...;

D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

Which of the following statements about a table with a LOB column is TRUE?

A. It doesn't need an auxiliary table if it has an inline LOB

B. It must also have a ROWID column and an auxiliary table

C. It doesn't need a ROWID column (implicit or explicit) if a LOB locator will be used

D. It must be in a partitioned by growth (PBG) universal table space with a ROWID column

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