000-610 DB2 10.1 Fundamentals (Exam 1)

000-610 DB2 10.1 Fundamentals (Exam 1)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • If the following command is executed: CREATE DATABASE test What is the page size (...

  • Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wi...

  • Which DB2 object can be used to improve the execution performance of qualified SEL...

  • When is it appropriate to use a sequence?

  • Which object is a stored procedure defined into?

  • Which action needs to be performed in order to complete the definition of an appli...

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

  • You have a business need to query DB2 10 and DB2 9 databases and you want to write...

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

  • Which type of temporal table can be used to store only time-sensitive data?

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

  • What type of mechanism is a simple token value that is used to refer to a much big...

  • What is the purpose of the Query Tuner?

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

  • What is the primary function of an Online Transaction Processing (OLTP) workload?

  • What factor influences lock escalation?

  • Which type of lock allows the lock owner and all concurrent applications to read, ...

  • Application APP_A is performing updates to table TAB1 using the cursor stability (...

  • Which statement will prevent concurrent application processes from performing anyt...

  • When is an INTENT EXCLUSIVE (IX) lock required?

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