Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-611

IBM C2090-611 Exam Practice Questions (P. 1)

  • Full Access (118 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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?
  1. A
    RESTART DATABASE
  2. B
    RECOVER DATABASE
  3. C
    RESTORE TABLESPACE
  4. D
    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?
  1. A
    Crash recovery
  2. B
    Version recovery
  3. C
    Disaster recovery
  4. D
    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?
  1. A
    Assign the value ON to the DB2_HADR_ROS registry variable.
  2. B
    Assign the value ON to the DB2_HADR_SNAP registry variable.
  3. C
    Execute the STOP HADR command to temporarily break the HADR connection to the standby.
  4. D
    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?
  1. A
    RESTART DATABASE
  2. B
    RECOVER DATABASE
  3. C
    RESTORE DATABASE
  4. D
    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?
  1. A
    Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.
  2. B
    Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.
  3. C
    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.
  4. D
    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

Next Questions

All Pages