Question 1
Which command can you use to enable dual logging for a database named SAMPLE?
- A: db2set DB2_USE_FAST_LOG_PREALLOCATION=YES
- B: UPDATE DB CFG FOR sample USING failarchpath /ds/failarchlogs
- C: UPDATE DB CFG FOR sample USING mirrorlogpath /ds/mirrorlogs
- D: UPDATE DB CFG FOR sample USING logarchmeth2 TSM
Question 2
What type of recovery operation do you use to reapply transactions that were committed but not externalized to storage, to roll back transactions that were externalized to storage but not committed, and to purge transactions from memory that were neither committed nor externalized to storage?
- A: Disaster recovery
- B: Crash recovery
- C: Version recovery
- D: Roll-forward recovery
Question 3
Which command will restore a database by using information found in the recovery history log file?
- A: RESTART DATABASE
- B: RESTORE DATABASE
- C: RECOVER DATABASE...
