C2090-614 by IBM Actual Free Exam Questions And Answers

Question 1

What statement regarding Asynchronous index cleanup (AIC) is correct?

A. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

B. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).

C. AIC activates a newly attached partition after the index entries have been synchronized.

D. AIC removes all invalid index entries that refer to the attached partitions.

Discussion 0

Correct Answer: A Vote an answer

Question 2

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

B. Call the ADMIN_MOVE_TABLE procedure.

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

Discussion 0

Correct Answer: B Vote an answer

Question 3

What is the FAILARCHPATH database configuration parameter used for?

A. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.

B. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.

C. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.

D. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which item is NOT eligible for adaptive compression?

A. Indexes

B. Base tables

C. Inline LOB values

D. Temporary tables

Discussion 0

Correct Answer: D Vote an answer

Question 5

Which statement about compression dictionaries is FALSE?

A. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

B. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

C. Table-level dictionaries are stored in hidden rows within the table.

D. Page-level dictionaries are stored in hidden rows within the table.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

A. db2dart

B. inspect

C. db2mtrk

D. db2pd

Discussion 0

Correct Answer: D Vote an answer

Question 7

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

A. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

B. ALTER TABLESPACE tbsp1 REDUCE MAX

C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

D. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

Discussion 0

Correct Answer: D Vote an answer

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - C2090-614 Exam Practice Test

Contact Us

Useful Links

Latest Updated