DB2 10.1 DBA for Linux UNIX and Windows

Here you have the best IBM C2090-611 practice exam questions

You have 118 total questions to study from
Each page has 5 questions, making a total of 24 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 12, 2025
This site is not affiliated with or endorsed by IBM.

Question 1 of 118

Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". 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?

RESTART DATABASE

RECOVER DATABASE

RESTORE TABLESPACE

ROLLFORWARD DATABASE

Correct Answer: B

Question 2 of 118

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

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

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

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.

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.

Correct Answer: D

Question 3 of 118

Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

db2set ALT_DIAGPATH=/db2data/db2dump2

db2set SECONDARY_DIAGPATH=/db2data/db2dump2

UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Correct Answer: C

Question 4 of 118

What is the MAX_LOG database configuration parameter used for?

To limit how many log files a single transaction can span.

To limit the percentage of primary log space a running transaction can consume.

To limit the total number of primary and secondary log files a database can consume.

To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.

Correct Answer: B

Question 5 of 118

What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?

CPU cycles

Elapsed time, in milliseconds

Processing instructions performed

Timerons

Correct Answer: D