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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which type of key is defined on the child table to implement a referential constra...

  • Which of the following is NOT true about schemas?

  • When does a view get populated?

  • Given the following statements:CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3));CR...

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

  • The following triggers were defined for a table named SALES in the order shown:CRE...

  • Which of the following CREATE TABLE statements will NOT be successful?

  • If the following SQL statement is executed:CREATE TABLE sales(invoice_no NOT NULL ...

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

  • Which of the following will be a consequence of defining the column IDCOL2 in TABL...

  • What type of constraint can be used to ensure that, in any given row in a table, t...

  • Which of the following are all valid DB2 data types?

  • A view is created with the following statement:CREATE VIEW v1AS SELECT col1, col2,...

  • Which of the following is true of an index used to support a UNIQUE constraint?

  • A DBA has been asked to create a table which will contain a substantial amount of ...

  • If a unique constraint is defined on column COL1 of table TAB1, what are the chara...

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

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

  • The following triggers were defined for table TAB1 in the order shown:CREATE TRIGG...

  • Given the following requirements:Create a table named TESTTAB, which has an identi...

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

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings