Q1. Which authorizations can change the value of the subsystem parameter SYSADM using the u2013SET SYSPARM command? (Choose two.)

A. SYSADM

B. SECADM

C. SYSCTRL

D. Installation SYSADM

E. Installation SYSOPR

View Answer

Q2. Which types of user-defined data types are supported? (Choose two.)

A. CHAR

B. ARRAY

C. NUMERIC

D. DISTINCT

E. TIMESTAMP

View Answer

Q3. Which DB2 address space manages DB2 locking?

A. IRLM

B. DIST

C. DBM1

D. MSTR

View Answer

Q4. Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

A. SQLCA

B. SQLDA

C. SQLCODE

D. SQLSTATE

View Answer

Q5. 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 WHEREu2026;

D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;

View Answer

Q6. What is the result XQuery FLWOR expression when running the following scenario?

A. Joe Smith

B. <name> Joe Smith </name>

C. <employeeinfo><name> Joe Smith </name></employeeinfo>

D. <name> Joe Smith </name><department name>DB2</department name>

View Answer

Q7. You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

A. MSTR

B. DBM1

C. DIST

D. IRLM

View Answer

Q8. Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

A. 10 row locks

B. 200 page locks

C. A single table space lock

D. 6 partition locks (given a table space with a total of 10 partitions)

View Answer

Q9. COL1 is defined as CHAR(05) and contains CHAR(u202112345u2021). Which of the following expressions returns the digits 12345 for further calculation?

A. HEX(COL1)

B. DEC(COL1)

C. PACK(COL1)

D. DIGITS(COL1)

View Answer

Q10. Which of the following is TRUE for using LOAD on a partition-by-growth table space?

A. Data can only be loaded at the partition level

B. Data can only be loaded at the table space level

C. Data can only be loaded using a clustering index

D. Data can be loaded at either the table space level or the partition level

View Answer