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 types of user-defined data types are supported? (Choose two.)

A. CHAR

B. ARRAY

C. NUMERIC

D. DISTINCT

E. TIMESTAMP

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

Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascending order by department?

A. SELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;

B. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;

C. SELECT workdept, MAX(salary) FROM employee ORDER BY workdept;

D. SELECT workdept, MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;