C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 1)

C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 1)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • On which two operating systems can DB2 pureScale run? (Choose two.)

  • Which statement about data type mappings is true in a federated system?

  • Which statement about IBM WebSphere Information Integrator Q Replication is correct?

  • Which table configuration CANNOT utilize multi-temperature storage?

  • What is the preferred method for reclaiming unused storage in a DMS table space?

  • If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/pa...

  • A DB2 9 database named MYDB that does not use automatic storage was migrated to DB...

  • The following statement was used to create a table space named USER_TMP in a non-p...

  • A DBA wants to create a set of tables in a storage group named SG_1, but no table ...

  • What contributes to the efficient use of block-based buffer pools?

  • What is a benefit of multi-temperature data storage?

  • A storage group named HOT_SG was created as follows:What does the DATA TAG 1 claus...

  • Which statement about partitioned indexes is FALSE?

  • What must be done to convert an existing table into an Insert-Time-Clustered (ITC)...

  • What statement regarding Asynchronous index cleanup (AIC) is correct?

  • A DBA wants to create a table named SALES that has the following characteristics:W...

  • Which Range-Clustered Tables (RCT) statement is correct?

  • A table named SALES was created as follows:Assuming all table spaces required alre...

  • In which scenario should a DBA consider creating a multidimensional clustering (MD...

  • A DBA wants to create a table named SALES that has the following characteristics: ...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    7 views
    people
    0 takers
    folder
    IBM

  • C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 1) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings