IBM IBM Certified Advanced Database Administrator C2090-611 Questions & Answers

• Question 71:

  A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?

  A. Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.

  B. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.

  C. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.

  D. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.

  Correct Answer: D

• Question 72:

  Which statement about BEFORE triggers is FALSE?

  A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

  B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

  C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

  D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

  Correct Answer: B

• Question 73:

  What are two purposes of the SET INTEGRITY statement? (Choose two.)

  A. To bring a table out of "Set Integrity Pending" state by performing the required integrity processing on the table.

  B. To bring a table out of "Set Integrity Pending" state by performing only check constraint processing on the table.

  C. To bring a table out of "Set Integrity Pending" state without performing the required integrity processing on the table.

  D. To bring a table out of "Set Integrity Pending" state by performing only referential integrity constraint processing on the table.

  E. To bring a table out of "Set Integrity Pending" state by performing only referential integrity and check constraint processing on the table.

  Correct Answer: AC

• Question 74:

  You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

  A. Alter the view and add the ENFORCE SELECT clause to the view definition.

  B. Drop and recreate the view with the WITH CHECK OPTION clause specified.

  C. Alter the view and add the WITH CHECK OPTION clause to the view definition.

  D. Create a new view with the same name and the ENFORCE SELECT clause specified.

  Correct Answer: B

• Question 75:

  What is an informational constraint?

  A. A constraint that defines a relationship to a federated object.

  B. A constraint that is used by the optimizer but is not enforced.

  C. A constraint that provides Information to the RUNSTATS utility.

  D. A constraint that is created from information supplied to the design advisor.

  Correct Answer: B

• Question 76:

  A partitioned table named SALES was created as follows: Which statement about the PARTS_IDX index is true?

  

  A. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP3.

  B. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0.

  C. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.

  D. The index PARTS_IDX will contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2.

  Correct Answer: D

• Question 77:

  An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

  A. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.

  B. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.

  C. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.

  D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.

  Correct Answer: D

• Question 78:

  Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

  A. The table is not a system temporary table.

  B. The table contains a sufficient amount of data.

  C. A table-level compression dictionary does not already exist for the table.

  D. A page-level compression dictionary does not already exist for the table.

  E. The table does not have any indexes defined on it that have not been enabled for compression.

  Correct Answer: BC

• Question 79:

  Which statement about Binary XML is FALSE?

  A. Binary XML format is only used for data transmission.

  B. Binary XML data refers to data that is in the XDBX format.

  C. Only textual XML data format is supported by Binary XML.

  D. The binary format provides a faster way to transmit and receive XML data.

  Correct Answer: C

• Question 80:

  Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?

  A. String

  B. Binary

  C. Delimited ASCII

  D. Non-delimited ASCII

  Correct Answer: B