000-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 4)

000-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which system command can be used to locate and return only ADM4500W messages from ...

  • Which statement about the db2pd tool is true?

  • If you are running DB2 in clustered environment, what utility should you use to ge...

  • Which user-managed file system is required for DB2 pureScale deployments?

  • What information can be obtained by analyzing EXPLAIN data?

  • Which tool should be used to collect data during a potential hang without stopping...

  • Which action can a DBA take to retrieve bufferpool metrics information?

  • Which tool should be used to give you lock wait information from the DB2 memory sets?

  • A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORA...

  • Which type of table space can be associated with only one storage group?

  • How can you remove all effects of compression from an index?

  • Which SQL data type CANNOT be used to store XML indexed values?

  • Which table space is NOT created by default when the CREATE DATABASE command is ex...

  • Which statement is correct when describing Range Clustered Tables (RCT) as compare...

  • If the following statements are executed in the order shown: Which statement is true?

  • When the ALTER TABLE DETACH operation is used to detach a single data partition fr...

  • Which statement regarding compression for temporary tables is true?

  • When a table space is moved to a new storage group, what action will occur for the...

  • Which SQL/XML publishing function can be used to convert XML data into other forma...

  • If the following command is executed:CREATE DATABASE sample RESTRICTIVEWhich state...

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-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 4) QR code