000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 4)

000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • When using an online backup recovery strategy, what steps are required to backup a...

  • What is the correct setting for the DIAGSIZE database manager configuration parame...

  • A DB2 9.7 database has been enabled for Oracle compatibility. What is the command ...

  • If table space TS is created as follows: CREATE TABLESPACE ts MANAGED BY DATABASE ...

  • The SALES database was created without AUTOMATIC STORAGE. If the following command...

  • Given the following DDL statements:What is the end result of the CREATE UNIQUE IND...

  • Which of the following is possible using pureXML feature in partitioned database e...

  • If table TAB_A and index TABA_IDX are created as follows:What can be compressed?

  • Click on the Exhibit buttonGiven the following DDL statements:If COL2 contains XML...

  • Given the following SQL statement:Assuming that a temporary table is created by DB...

  • When using an SQL UPDATE statement on an XML column, which statement is valid?

  • In a partitioned database environment, a table's distribution key can have:

  • If the file DATA.DEL contains 100,000 records and these statements/commands are ex...

  • A range-partitioned table TAB1 has been created with COL1 and COL2 with COL1 as th...

  • If DB2 load operation is performed against a table which contains at least one XML...

  • Which of the following statements will load XML data with white spaces removed int...

  • A table named TAB_A has a primary key and 2 additional indexes that were created b...

  • You have installed a copy of DB2 on your windows server. After the installation yo...

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

  • 000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 4) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings