000-610 DB2 10.1 Fundamentals (Exam 6)

000-610 DB2 10.1 Fundamentals (Exam 6)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which statement about roll back operations is correct?

  • Which SQL statement should be used to retrieve the minimum and maximum salaries (S...

  • If a table named MY_TAB contains 100 rows and the following statement is executed:...

  • An SQL function named DEPT_INFO was created as follows:What is the correct way to ...

  • Which type of stored procedure is not associated with an external application prog...

  • Which SQL statement will retrieve the department number (WORKDEPT) and averagedepa...

  • Which statement about system-period temporal tables is true?

  • Which statement about UPDATE processing is FALSE?

  • Given the following statements:What will be the result?

  • A table named STATES has the following columns: STATE_CD, REGION_CD, andSTATE_NAME...

  • What is a function of a table check constraint?

  • Which statement about foreign keys is true?

  • Which type of table is best suited for recording results from application data man...

  • Which statement regarding referential integrity constraints is true?

  • Which database object provides an alternative way of describing data that exists i...

  • The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which o...

  • Which type of constraint can be used to tell the DB2 Optimizer that a parent-child...

  • Which event will NOT cause a trigger to be fired?

  • What is the primary purpose for using the INCLUDE clause with a CREATE UNIQUE INDE...

  • What are INSTEAD OF triggers used for?

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