C. 2 D. 3 Answer: C QUESTION: 294 In which of the following situations would DB2 retain resources associated with a transaction at COMMIT time? A. A cursor is defined as WITH HOLD. B. Another user executes the same transaction. C. The application program amends during COMMIT. D. The transaction terminates abnormallyduring COMMIT. Answer: A QUESTION: 295 Given the following two tables: TAB1 R1 -- A A A B B C C D E TAB2 R2 -- A A B B C C D Which of the following queries returns the following result set? RETVAL ------ E A. SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2 B. SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2 C. SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2 D. SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2 B QUESTION: 296 Given the following two tables: TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- -- D 23 Which of the following queries will yield thedesired results? D QUESTION: 297 When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?