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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Due to a hardware failure, it appears that there may be some corruption in databas...

  • You have an High Availability and Disaster Recovery (HADR) environment set up and ...

  • Which command will define the alternate diagnostic data directory path as /db2data...

  • What is the MAX_LOG database configuration parameter used for?

  • A table named SALES was created as follows:If management wants to use Label-Based ...

  • Which of the following table types is NOT supported by the load utility?

  • If the following command is executed:Which statement is true?

  • If an MQT named Q1_SALES was created as follows:Which statement will execute succe...

  • Table TAB1 was created as follows:Which statement(s) should be used to create an i...

  • Given a system-period temporal table POLICY_INFO with its associated history table...

  • An existing non-automatic storage database named MYDB has been successfully conver...

  • Given the following statement:How many constraints are present in the DEPARTMENT t...

  • Which statement about the db2pd tool is true?

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

  • Which is the suggested way to restore a database with a subset of its original tab...

  • Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECAD...

  • What type of Label-Based Access Control (LBAC) security label component is used to...

  • What is the purpose of the Design Advisor?

  • If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL Wh...

  • Which statement about primary keys is true?

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
    2 completed
    remove_red_eye
    11 views
    people
    0 takers
    folder
    IBM

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings