Download IBM.C2090-611.Prep4Sure.2019-02-24.118q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-611 |
| Exam Name: | DB2 10.1 DBA for Linux, UNIX, and Windows |
| Date: | Feb 24, 2019 |
| File Size: | 827 KB |
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
