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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Given the following tables:YEAR_2006EMPID NAME1 Jagger, Mick2 Richards, Keith3 Woo...

  • Which of the following best describes a unit of work?

  • Given the following set of statements:CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(2...

  • Given the following table:TAB1COL1 COL2A 10B 20C 30D 40E 50And the following SQL s...

  • A stored procedure has been created with the following statement:CREATE PROCEDURE ...

  • Given the following table:TEMP_DATATEMP DATE45 12/25/200651 12/26/200667 12/27/200...

  • Which of the following is a valid DB2 data type?

  • Which of the following DB2 data types does NOT have a fixed length?

  • Which of the following is the best statement to use to create a user-defined data ...

  • Which of the following DB2 data types can be used to store 1000 MB of single-byte ...

  • Which of the following DB2 data types can NOT be used to create an identity column?

  • Which of the following strings can NOT be inserted into an XML column using XMLPAR...

  • Which two of the following are optional and do not have to be specified when creat...

  • Which of the following can NOT be used to restrict specific values from being inse...

  • Given the following CREATE TABLE statement:CREATE TABLE table2 LIKE table1Which tw...

  • If the following SQL statements are executed:CREATE TABLE tab1 (id SMALLINT NOT NU...

  • Which of the following is used to indicate a column will not accept NULL values an...

  • If table TAB1 is created using the following statement:CREATE TABLE tab1 (col1 INT...

  • Which of the following is NOT a characteristic of a unique index?

  • If the following statement is executed:CREATE TABLE employee(empid INT NOT NULL GE...

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
    2 views
    people
    0 takers
    folder
    IBM

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings