000-730 DB2 9 Fundamentals (Exam 2)

000-730 DB2 9 Fundamentals (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which of the following DB2 products are required on an iSeries or system I server ...

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

  • Which of the following statements allows BOB to revoke access to the SAMPLE databa...

  • Which of the following is NOT true about XML columns?

  • The Employee table Contains the following information. Please refer to the exhibit.

  • The following statements:How many rows will be deleted by the following DELETE sta...

  • Which of the following strings can be inserted into an XML column using XMLPARSE?

  • Which of the following actions may cause a trigger to be fired?

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

  • What is the maximum size that can be specified when creating an XML column in a DB...

  • The following SQL statements were executed in sequence:What is the current content...

  • Which of the following DB2 data types has a fixed length?

  • A view is created with the following statements:What is the effect of the CHECK OP...

  • The opening of cursor CSR01 produces the following result set:Which of the followi...

  • Which of the following will DELETE all of the rows from the table T03?

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

  • Given the following two tables:Which of the following queries will yield the desir...

  • A View is created with the following statements:When will DB2 access the data from...

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

  • Given the following DDL for the PARTS table:All part numbers entered will be diffe...

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

  • 000-730 DB2 9 Fundamentals (Exam 2) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings