← Back to exam page

C2090-543 – DB2 9.7 Application Development

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Volume B)

Which two SQL statements demonstrate the correct usage of a parameter marker? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    DELETE FROM employee WHERE empno = ?
  • ○

    SELECT ? FROM employee
  • ○

    VALUES(?) INTO :hvar1
  • ○

    SET CURRENT SQLID = ?
Question 5 (Volume B)

Click the Exhibit button.

CREATE TABLE gradereport(sid INTEGER, info XML);

INSERT INTO gradereport VALUES (1,

'

John Smith

No

ECE10080

CSC10070

MAT10060

416-333-8725

');

Given the statements shown in the exhibit, which two queries can be used to return the semester average of the student? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
    let $sum := fn:sum($studinfo/grades/course/grade),
    $count := fn:count($studinfo/grades/course/grade)
    return $sum div $count
  • ○

    XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
    let $average := fn:average($studinfo/grades/course/grade)
    return $average
  • ○

    XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
    let $avg := fn:avg($studinfo/grades/course/grade)
    return $avg
  • ○

    XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
    let $avg := fn:avg($studinfo/grades/course)
    return $avg
Question 6 (Volume A)

Which statement is true of an application that only uses static SQL?

Select an option, then click Submit answer.

  • ○

    The authorization ID of program creator is used to qualify explicitly qualified table references on a DROP statement.
  • ○

    Static SQL uses SQLDA to determine the number of rows successfully fetched on a FETCH statement.
  • ○

    The authorization ID of application creator is used to qualify implicitly qualified view references on an UPDATE statement.
  • ○

    The authorization ID of application invoker used by DB2 to perform authorization checking of an embedded OPEN statement during execution.