000-610 DB2 10.1 Fundamentals (Exam 5)

000-610 DB2 10.1 Fundamentals (Exam 5)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • When an index is created for a table, where is the metadata for that index stored?

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

  • Which statement is true regarding constraints?

  • Which statement about BEFORE triggers is FALSE?

  • Which case will require a sequence to be dropped and recreated instead of being mo...

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

  • What privilege is required to create a view on a table that you are not the owner of?

  • Which SQL statement will give a user named USER1 the ability to run an embedded SQ...

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

  • Which object can be enabled for compression?

  • Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

  • Which statement about bitemporal tables is valid?

  • Which object can a buffer pool be assigned to?

  • Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

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

  • Which statement about large object (LOB) locators is true?

  • Which DB2 product is a database cluster solution for non-mainframe platforms and i...

  • Which DB2 product is NOT suitable for very large data warehouse applications?

  • Which platform supports DB2 pureScale environments?

  • A table named SALES contains a record for every sales transaction a company proces...

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