C2090-610 DB2 10.1 Fundamentals (Exam 2)

C2090-610 DB2 10.1 Fundamentals (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which SQL statement should be used to select the minimum and maximum salaries (SAL...

  • If a user has been granted SYSCTRL authority, which activities can they perform?

  • 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...

  • 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 statement is true about an index that is used to support a UNIQUE constraint?

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

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

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

  • What is the primary purpose of a view?

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

  • Which statement is true regarding constraints?

  • 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...

  • Which method for restricting data access relies on a SQL search condition that des...

  • When is a mask used to limit access to data in a table?

  • Which of the following privileges allow a user to update the comment on a sequence?

  • Which statement is valid about the Row and Column Access Control (RCAC) feature?

Dec. 11, 2016
review by None R (@jaks)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    1 completed
    1 takers

  • C2090-610 DB2 10.1 Fundamentals (Exam 2) QR code