IBM DB2 10.1 DBA for Linux, UNIX, and Windows - C2090-611 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which is the suggested way to restore a database with a subset of its original table spaces?

A. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed. B. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed. C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded. D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.

Discussion 0

Correct Answer: B Vote an answer

Question 2

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 contain 3 partitions; the first partition will be stored in table space TBSP0, the second in TBSP1, and the third inTBSP2. C. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table space TBSP0. D. The index PARTS_IDX will contain 3 partitions and all three partitions will be stored in table space TBSP3.

Discussion 0

Correct Answer: B Vote an answer

Question 3

Which statement about triggers is FALSE?

A. A trigger's code block can be executed either before or after a triggering event. B. A statement-level trigger fires only once for each SQL statement. C. A row-level trigger fires once for each row that is affected by a triggering event. D. A table-level trigger fires once for each table that is affected by a triggering event.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE; B. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE; C. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';
ALTER TABLESPACE my_ts REBALANCE; D. ALTER TABLEPACE my_ts MANAGED BY DATABASE;
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;
ALTER TABLESPACE my_ts REBALANCE;

Discussion 0

Correct Answer: A Vote an answer

Question 5

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

A. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED B. ALTER TABLE mytab CHECK (COL IS VALIDATED) C. SET INTEGRITY FOR mytab IMMEDIATE CHECKED D. ALTER TABLE mytab ALLOW READ ACCESS;
SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which statement regarding compression for temporary tables is true?

A. Compression for temporary tables can be dynamically enabled and disabled. B. Temporary tables can only be compressed using classic row compression. C. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables. D. Temporary tables can only be compressed using adaptive compression.

Discussion 0

Correct Answer: B Vote an answer

Question 7

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 does not have any indexes defined on it that have not been enabled for compression. C. A page-level compression dictionary does not already exist for the table. D. A table-level compression dictionary does not already exist for the table. E. The table contains a sufficient amount of data.

Discussion 0

Correct Answer: D,E Vote an answer