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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • How does DB2 protect the integrity of indexes when data is updated?

  • Application A currently holds an exclusive lock on a single row and application B ...

  • Which of the following resources can be referenced in the LOCK statement?

  • If application A issues the following SQL statement, which of the following statem...

  • Which of the following best describes the lock protection provided by DB2 for the ...

  • Which of the following best describes the lock protection provided by DB2 for the ...

  • Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?

  • Application A is designed to execute the following SQL statements within a single ...

  • Application A holds an Update lock on a single row and application B is trying to ...

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

  • Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workd...

  • Which kind of non-sourced UDF can be created so that it only returns a single value?

  • Given that tables T1 and T2 contain the following rows:Table T1:C1 C21 41 31 2Tabl...

  • Which of the following will begin a new unit of work?

  • The EMPLOYEE table contains the following information:EMPNO NAME WORKDEPT101 SAM A...

  • Given the following table definition:STOCK:item VARCHAR(30)status CHAR(1)quantity ...

  • In which of the following situations would DB2 retain resources associated with a ...

  • Given the following two tables:TAB1R1AAABBCCDETAB2R2AABBCCDWhich of the following ...

  • Given the following two tables:TAB1C1 C2A 11B 12C 13TAB2CX CYA 21C 22D 23The follo...

  • When defining a referential constraint between the parent table T2 and the depende...

starstarstarstar_borderstar_border
Nov. 29, 2016
review by shiny s (@jyothi)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    1 completed
    remove_red_eye
    6 views
    people
    1 takers
    folder
    IBM

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

Ratings

starstarstarstar_borderstar_border
ratings