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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which of the following can be used to ensure that once a row has been inserted in ...

  • Which of the following supports the XML data type?

  • A trigger can be created on which of the following objects?

  • Given the requirements to store employee names, employee numbers, and when employe...

  • Given the requirements to store customer names, billing addresses, and telephone n...

  • Which of the following is a NOT a valid reason for defining a view on a table?

  • An application needs to store a 5 MB JPEG image in a DB2 table. Which data type sh...

  • Which of the following scenarios will ensure that the value of the NEXT_STEPNO col...

  • Which of the following is a characteristic of a schema?

  • Which of the following database objects can be used to raise an error if a table i...

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

  • Which of the following constraint types can be used to ensure the value of an INTE...

  • What type of constraint is used to ensure that each row inserted into the EMPLOYEE...

  • Given the following table definition:EMPLOYEESEMPID INTEGERNAME CHAR(20)SALARY DEC...

  • Given the statement:CREATE TABLE tablea (col1 INTEGER NOT NULL,CONSTRAINT const1 C...

  • Which of the following deletion rules on CREATE TABLE will allow parent table rows...

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

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

  • A UDT is a data type which:

  • Given the following scenario:Table TABLE1 needs to hold specific numeric values up...

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 10) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings