File Info
| Exam | DB2 10.1 DBA for Linux, UNIX, and Windows |
| Number | C2090-611 |
| File Name | IBM.C2090-611.Prep4Sure.2019-02-24.118q.vcex |
| Size | 516 KB |
| Posted | Feb 24, 2019 |
| Download | IBM.C2090-611.Prep4Sure.2019-02-24.118q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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
If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?
- Crash recovery
- Version recovery
- Disaster recovery
- Roll-forward recovery
Correct answer: A
Question 3
You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?
- Assign the value ON to the DB2_HADR_ROS registry variable.
- Assign the value ON to the DB2_HADR_SNAP registry variable.
- Execute the STOP HADR command to temporarily break the HADR connection to the standby.
- Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
Correct answer: A
Question 4
Which command can be used to restore a corrupted database using only the recovery history file?
- RESTART DATABASE
- RECOVER DATABASE
- RESTORE DATABASE
- ROLLFORWARD DATABASE
Correct answer: B
Question 5
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 6
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 7
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 8
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
Question 9
In IBM Data Studio, where can you schedule script-based jobs?
- Job Console
- Job Manager
- Task Manager
- Utilities Console
Correct answer: B
Question 10
The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:
What commands must be run to enable real-time statistics collection on the SAMPLE database?
- UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
- 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;
- 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;
- UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
Correct answer: B
