000-610 DB2 10.1 Fundamentals (Exam 3)

000-610 DB2 10.1 Fundamentals (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which SQL statement will give user USER1 the ability to assign a comment to a sequ...

  • A column mask that is to be used for row and column access control (RCAC) was crea...

  • User USER1 holds both DBADM and SECADM authority and you want to separate database...

  • A table named EMPLOYEE was created as follows:Which action will prevent unauthoriz...

  • Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

  • A new user named USER1 needs to retrieve information from a database named MYDB. W...

  • Which privilege is required to invoke a user defined function?

  • Which statement is true about an index that is used to support a UNIQUE constraint?

  • Which statement regarding triggers is true?

  • A table named STATES was created as follows:What will happen?

  • When an application using a temporary table terminates or disconnects from the dat...

  • When a user-defined function (UDF) is created and no schema is specified, what sch...

  • Which statement about triggers is true?

  • Which two statements are true about foreign key constraints? (Choose two.)

  • What is the primary purpose of a view?

  • By default, a column defined as a TIMESTAMP includes which attributes?

  • Which is NOT a valid reason for creating an index?

  • Which type of constraint can be used to ensure that an INTEGER column in a table w...

  • By default, where is the data stored for a column defined with an XML data type?

  • What is used in conjunction with a foreign key to define a relationship between tw...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:49 a.m.
    20 questions
    0 completed
    0 takers

  • 000-610 DB2 10.1 Fundamentals (Exam 3) QR code