Free C2090-320 Exam Braindumps (page: 12)

Page 11 of 31

Which types of user-defined data types are supported? (Choose two.)

  1. CHAR
  2. ARRAY
  3. NUMERIC
  4. DISTINCT
  5. TIMESTAMP

Answer(s): B,D


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_userdefineddatatypes.html



Which BIND option determines when DB2 will do authorization checking?

  1. DEFER
  2. DEPLOY
  3. VALIDATE
  4. CURRENTDATA

Answer(s): C


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_bindoptvalidate.html



COL1 is defined as CHAR(05) and contains CHAR(‘12345’). Which of the following expressions returns the digits 12345 for further calculation?

  1. HEX(COL1)
  2. DEC(COL1)
  3. PACK(COL1)
  4. DIGITS(COL1)

Answer(s): B



Which DB2 address space manages DB2 locking?

  1. IRLM
  2. DIST
  3. DBM1
  4. MSTR

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/inst/src/tpc/ db2z_irlmaddrspcstgreq.html






Post your Comments and Discuss IBM C2090-320 exam with other Community members:

C2090-320 Exam Discussions & Posts