C2090-730 DB2 9 Family Fundamentals Exam (Exam 11)

C2090-730 DB2 9 Family Fundamentals Exam (Exam 11)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Given the following statement:CREATE TABLE tab1(col1 SMALLINT NOT NULL PRIMARY KEY...

  • Given the following tables:TABLEAEMPIDNAME1 USER12 USER2TABLEBEMPID WEEKNO PAYAMT1...

  • Which of the following is NOT a difference between a unique index and a primary key?

  • Which of the following is NOT a characteristic of a declared temporary table?

  • Which of the following isolation levels will lock all rows scanned to build a resu...

  • Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclus...

  • A transaction using the Read Stability isolation level scans the same table multip...

  • Two applications have created a deadlock cycle in the locking subsystem. If lock t...

  • Application A is running under the Repeatable Read isolation level and holds an Up...

  • Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, w...

  • To which of the following resources can a lock NOT be applied?

  • Which of the following causes a lock that is being held by an application using th...

  • Which of the following modes, when used with the LOCK TABLE statement, will cause ...

  • An application has acquired a Share lock on a row in a table and now wishes to upd...

  • Application A issues the following SQL statements within a single transaction usin...

  • Which of the following resources can be explicitly locked?

  • Application A issues the following SQL statements within in a single transaction u...

  • 60 Which of the following best describes how locks are used in DB2?

  • If an application issues the same query more than once in the same Unit of Work, w...

  • If DB2 detects a deadlock between application A and application B (each waiting fo...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    7 views
    people
    0 takers
    folder
    IBM

  • C2090-730 DB2 9 Family Fundamentals Exam (Exam 11) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings