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

Select all that apply, then click Submit answer.

• ○

  CLOB
  

• ○

  CHAR
  

• ○

  DOUBLE
  

• ○

  BLOB
  

• ○

  GRAPHIC
  

Select all that apply, then click Submit answer.

• ○

  INSPECT
  

• ○

  FLUSH PACKAGE CACHE
  

• ○

  REBIND
  

• ○

  RUNSTATS
  

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.
  

Select all that apply, then click Submit answer.

• ○

  DELETE FROM employee WHERE empno = ?
  

• ○

  SELECT ? FROM employee
  

• ○

  VALUES(?) INTO :hvar1
  

• ○

  SET CURRENT SQLID = ?
  

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
  

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.
  

Select an option, then click Submit answer.

• ○

  SQLMoreResults()
  

• ○

  SQLFetchScroll()
  

• ○

  SQLGetInfo()
  

• ○

  SQLGetData()
  

Select an option, then click Submit answer.

• ○

  DTD
  

• ○

  RelaxNG
  

• ○

  XMLSchema
  

• ○

  Schematron
  

Select an option, then click Submit answer.

• ○

  2
  

• ○

  2
  

• ○

  1
  

• ○

  $count
  

Select an option, then click Submit answer.

• ○

  0
  

• ○

  1
  

• ○

  2
  

• ○

  3