C2090-610 DB2 10.1 Fundamentals (Exam 5)

C2090-610 DB2 10.1 Fundamentals (Exam 5)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAM...

  • Which statement about foreign keys is true?

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

  • User USER1 wants to store part numbers and part descriptions in a table named PART...

  • Which data type should be used to store data in a column that represents money and...

  • What is the act of releasing a large number of row-level locks that an application...

  • What factor influences lock conversion/promotion?

  • If no isolation level is specified, what is the default isolation level used?

  • What functionality allows users to perform a UNION operation between a DB2 table a...

  • Which two activities indicate the need for a data warehouse? (Choose two.)

  • Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all ...

  • Given the following statement:GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTI...

  • Which two DB2 objects can a view be derived from? (Choose two.)

  • Which statement regarding referential integrity constraints is true?

  • What are two valid objects that can be created in DB2? (Choose two.)

  • What is the purpose of the Query Tuner?

  • An SQL function designed to convert temperatures from Fahrenheit to Celsius was cr...

  • Which command will delete all rows from a table without generating log records?

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

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

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