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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • If the following command is executed:Which statement is true?

  • Which statement describes adaptive row compression?

  • If the following statement is executed:What indexes will be created for table TAB1?

  • Which statements will enable automatic storage in storage group SG_HOT for a given...

  • Which statement about range-clustered tables is true?

  • Which tool can be used to mimic statistics for tables by gathering statistics from...

  • You have just converted an existing database to an automatic storage database. Wha...

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

  • Which statement about the ADMIN_MOVE_TABLE procedure is true?

  • Which statement about Binary XML is FALSE?

  • Which XML format provides a faster way to transmit and receive XML data between Ja...

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

  • Which two conditions must be met before Automatic Dictionary Creation (ADC) can be...

  • A partitioned table named SALES was created as follows:Which statement about the P...

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

  • Which statement about BEFORE triggers is FALSE?

  • You want to modify an existing view so that any rows that are inserted or updated ...

  • What is an informational constraint?

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

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