← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1 (Volume A)

Which three data types are supported as output of the XMLSERIALIZE function? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    CLOB
  • ○

    CHAR
  • ○

    DOUBLE
  • ○

    BLOB
  • ○

    GRAPHIC
Question 2 (Volume B)

Which two commands can be used to make use of the latest statistics? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    INSPECT
  • ○

    FLUSH PACKAGE CACHE
  • ○

    REBIND
  • ○

    RUNSTATS
Question 3 (Volume B)

Which two statements are true regarding performing batch updates in JDBC? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    SELECT statements can be included in batch update operations.
  • ○

    The addBatch() method can be used to add a set of input parameter values to the batch.
  • ○

    ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
  • ○

    The executeBatch() method can be used to execute a batch of statements.