Assessment-DB2-9-Fundamentals-Assessment-(A2090-730).pdf - IBM A2090-730 Assessment DB2 9 Fundamentals-Assessment

Assessment-DB2-9-Fundamentals-Assessment-(A2090-730).pdf -...

This preview shows page 1 - 4 out of 8 pages.

A2090-730 IBM Assessment: DB2 9 Fundamentals-Assessment
Image of page 1
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
Image of page 2
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?
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '16
  • Mohammad Alizadeh

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture