Free C2090-616 Exam Braindumps (page: 6)

Page 5 of 16

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

  1. Direct Standard Edition
  2. Enterprise Server Edition
  3. Workgroup Server Edition
  4. DB2 Direct Advanced Edition
  5. Advanced Enterprise Server Edition

Answer(s): B,C



Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

  1. COMMIT
  2. SAVEPOINT
  3. ROLLBACK WORK
  4. UPDATE TERMINATE

Answer(s): C



Which of the following authorities are sufficient for creating a database? (Choose two.)

  1. DBADM
  2. SYSADM
  3. SECADM
  4. SYSCTRL
  5. SYSMAINT

Answer(s): B,D



Which operation typically requires a Share (S) lock?

  1. INSERT
  2. SELECT
  3. DELETE
  4. UPDATE

Answer(s): B






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

C2090-616 Discussions & Posts