C2090-610 DB2 10.1 Fundamentals (Exam 3)

C2090-610 DB2 10.1 Fundamentals (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which object can be enabled for compression?

  • A table named EMPLOYEES was created as follows:What will be the results?

  • What needs to be defined in order to track changes made to a system-period tempora...

  • Which object is used to cache table and index data as it is read from disk?

  • Which platform supports DB2 pureScale environments?

  • Which tool allows users to connect to a DB2 database using a wizard?

  • Which statement about roll back operations is correct?

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

  • A table named DEPARTMENT contains the following data:What will happen?

  • Which statement about UPDATE processing is FALSE?

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

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

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

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

  • What are INSTEAD OF triggers used for?

  • User USER1 wants to define a required relationship between two tables named TAB1 a...

  • What takes place when a process accesses a data object on which it already holds a...

  • Which DB2 object is used to provide a logical grouping of other database objects?

  • Which product is used to customize execution environments for the purpose of contr...

  • What is the act of exchanging one lock an application holds on a resource for a mo...

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