Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

IBM C2090-611 Exam Actual Questions

The questions for C2090-611 were last updated on Nov. 1, 2024.
  • Viewing page 1 out of 30 pages.
  • Viewing questions 1-4 out of 118 questions
 

Topic 1 - Volume A

Question #1 Topic 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?

  • A. RESTART DATABASE
  • B. RECOVER DATABASE
  • C. RESTORE TABLESPACE
  • D. ROLLFORWARD DATABASE
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

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?

  • A. Crash recovery
  • B. Version recovery
  • C. Disaster recovery
  • D. Roll-forward recovery
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #3 Topic 1

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?

  • A. Assign the value ON to the DB2_HADR_ROS registry variable.
  • B. Assign the value ON to the DB2_HADR_SNAP registry variable.
  • C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
  • D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #4 Topic 1

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

  • A. RESTART DATABASE
  • B. RECOVER DATABASE
  • C. RESTORE DATABASE
  • D. ROLLFORWARD DATABASE
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel