← Back to exam page

Free C2090-616 – DB2 11.1 Fundamentals for LUW Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    No other applications can access the table
  • ○

    Only uncommitted read (UR) applications can access the table
  • ○

    The lock owner and other applications can read, but not update, the locked table
  • ○

    The lock owner can both read and update datA. Other applications can read the table
  • ○

    This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on
    the table is dropped
Question 5

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

Select all that apply, then click Submit answer.

  • ○

    DBADM
  • ○

    SYSADM
  • ○

    SECADM
  • ○

    SYSCTRL
  • ○

    SYSMAINT
Question 6

Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?

Select an option, then click Submit answer.

  • ○

    UPDATE t1 c1 = ‘DB2, c2’ = 11
  • ○

    UPDATE t1 SET c1 = ‘DB2, c2’ = 11
  • ○

    UPDATE t1 c1 = ‘DB2’, c2 = 11 WHERE c3 = 2016
  • ○

    UPDATE t1 SET (c1, c2) = (‘DB2’, 11) = WHERE c3 = 2016