C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 3)

C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • What authority is required to create, alter and drop workload management objects?

  • Which statement regarding snapshot administrative views and snapshot monitor table...

  • By analyzing EXPLAIN data, you notice that a table scan is being performed instead...

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

  • What information can be obtained by analyzing EXPLAIN data?

  • How is the time that an agent waits for log records to be flushed to disk calculated?

  • 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?

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

  • Which statement about adaptive compression is true?

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

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

  • Which statement is true about Insert Time Clustering (ITC) tables?

  • 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...

  • A user with SYSADM authority executes the following commands at host SERVER1:Assum...

  • Which command is used to import connectivity configuration information from a file...

  • Due to a hardware failure, it appears that there may be some corruption in databas...

  • Which statement is NOT true about a database restore operation?

  • Which High Availability Disaster Recovery (HADR) synchronization mode provides the...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    0 completed
    0 takers

  • C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 3) QR code