[Free] 2018(Jan) Dumps4cert Braindumps IBM C2090-611 Dumps with VCE and PDF 41-50

By | February 2, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-611
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-611.html

DB2 10.1 DBA for Linux, UNIX, and Windows

Question No: 41 – (Topic 1)

Which command can be used to restore a corrupted database using only the recovery history file?

  1. RESTART DATABASE

  2. RECOVER DATABASE

  3. RESTORE DATABASE

  4. ROLLFORWARD DATABASE

Answer: B

Question No: 42 – (Topic 1)

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

  1. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.

  2. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover thedropped table.

  3. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.

  4. Restore the appropriate table space from a backup image that was taken before the

table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Answer: D

Question No: 43 – (Topic 1)

The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:

Dumps4Cert 2018 PDF and VCE

What commands must be run to enable real-time statistics collection on the SAMPLE database?

  1. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

  2. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON; UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

  3. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON; UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;

    UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

  4. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON; UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

Answer: B

Question No: 44 – (Topic 1)

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

  1. A Temporal table

  2. A Range Partitioned table

  3. A Global Temporary table

  4. A MultidimensionalClustering table

Answer: C

Question No: 45 – (Topic 1)

If the following statement is executed:

Dumps4Cert 2018 PDF and VCE

What indexes will be created for table TAB1?

  1. 1dimension-block index and 1 composite-block index

  2. 1 dimension-block index and 3 composite-block indexes

  3. 3 dimension-block indexes and 1 composite-block index

  4. 3 dimension-block indexes and 3 composite-block indexes

Answer: C

Question No: 46 – (Topic 1)

Due to a hardware failure, it appears that there may be some corruption in databaseDB_1 as DB2 is reporting a quot;bad pagequot;. DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?

  1. RESTART DATABASE

  2. RECOVER DATABASE

  3. RESTORE TABLESPACE

  4. ROLLFORWARD DATABASE

Answer: B

Question No: 47 – (Topic 1)

A partitioned table named SALES was created as follows:

Dumps4Cert 2018 PDF and VCE

Which statement about the PARTS_IDX index is true?

  1. The index PARTS_IDX will be a nonpartitioned index and it will be stored in table spaceTBSP3.

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

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

  4. The index PARTS_IDX will contain 3partitions; the first partition will be stored in table

space TBSP0, the second in TBSP1, and the third in TBSP2.

Answer: D

Question No: 48 – (Topic 1)

Which command is used to export connectivity configuration information from a file known as a configuration profile?

  1. db2ca

  2. db2cfexp

  3. db2cfimp

  4. db2cfgexp

Answer: B

Question No: 49 – (Topic 1)

Which statement about BEFORE triggers is FALSE?

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

  2. A BEFORE trigger#39;s action is executed for each row in the set of affected rows instead of executing the trigger event.

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

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

Answer: B

Question No: 50 – (Topic 1)

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

  1. The table is not a system temporary table.

  2. The table contains asufficient amount of data.

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

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

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

Answer: B,C

100% Dumps4cert Free Download!
Download Free Demo:C2090-611 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-611 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.