000-610 DB2 10.1 Fundamentals (Exam 4)

000-610 DB2 10.1 Fundamentals (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which method for restricting data access relies on a SQL search condition that des...

  • Which SQL statement will take the ability to create tables in a table space named ...

  • When is a mask used to limit access to data in a table?

  • After creating several new indexes and executing RUNSTATS, user USER1 wants to re-...

  • Which statement is valid about the Row and Column Access Control (RCAC) feature?

  • Which type of table should you use if you want to define specific time periods whe...

  • Which SQL statement will create a DB2 object that can be used to store numerical d...

  • What is the minimum product required for DB2 connectivity across all platforms?

  • Which DB2 object limits the user's ability to retrieve data from a table by defini...

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

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

  • Which protocol provides applications the ability to connect to and update multiple...

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

  • What type of large object (LOB) is used to store LOB data together with the format...

  • Which product replaced the Control Center used in versions prior to DB2 v10?

  • Which SQL statement would be used to retrieve only salaries that are greater than ...

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

  • The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of ...

  • Which clause should be included in a ALTER TABLE statement to update a table defin...

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

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