← Back to exam page

Free C2090-543 – DB2 9.7 Application Development Practice Test Question

Free demo downloads

Loading demo links...

Showing 7–9 of 10 questions

Question 7 (Volume B)

A stored procedure is invoked that can return multiple result sets.

After processing the first result set, which CLI/ODBC API can be used to determine if another result set exists?

Select an option, then click Submit answer.

  • ○

    SQLMoreResults()
  • ○

    SQLFetchScroll()
  • ○

    SQLGetInfo()
  • ○

    SQLGetData()
Question 8 (Volume A)

Which standard is used for XML document validation in DB2?

Select an option, then click Submit answer.

  • ○

    DTD
  • ○

    RelaxNG
  • ○

    XMLSchema
  • ○

    Schematron
Question 9 (Volume A)

Click the Exhibit button.

CREATE TABLE store(sid INTEGER, info XML);

INSERT INTO store VALUES (1,

'

Grocery A

Mango1.20

Apple0.50

Ice Cream6.00

');

Given the statements shown in the exhibit, a user executes the query shown below:

XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := $store/items/fruit, $count := fn:count($items) return $count

What is the output?

Select an option, then click Submit answer.

  • ○

    2
  • ○

    2
  • ○

    1
  • ○

    $count