IBM A2090-541 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| DB2 Architecture and Concepts | - DB2 instance and database architecture
|
| Security and Authorization | - Data protection
|
| Installation and Configuration | - Instance configuration
|
| Database Operations and Utilities | - Backup and recovery
|
| Monitoring and Performance Tuning | - Performance monitoring
|
IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
Question #1
You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.)
A. The DISCOVERJNST parameter is enabled.
B. The database has not been cataloged.
C. The DISCOVER_DB parameter is disabled.
D. The database does not exist.
E. A network failure exists between the control center client and the database
Question #2
You want to federate communication between two databases. What are two key requirements? (Choose two.)
A. Define nicknames for the tables of a federated server.
B. Enable the client for federation.
C. Enable the server for federation.
D. Use the JDBC Type 4 driver.
Question #3
Which two DB2 commands are used to extract, format, and present diagnostic information? (Choose two.)
A. db2dart
B. db2diag
C. db2exfmt
D. db2xprt
Question #4
A database named PAYROLL was backed up on Sunday. On Tuesday, a table space in the PAYROLL database was renamed from TBSP1 to EMPINFO_TBSP. On Thursday, the database was restored from the backup image created on Sunday. Which command must be issued to roll the renamed table space forward to the current date and time?
A. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 TO empinfo_tbsp)
B. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbsp 1 RENAME empinfo_tbsp)
C. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(empinfo_tbsp)
D. ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOPTABLESPACE(tbspl)
Question #5
If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?
A. The damaged table space must be restored from the latest backup image. Once restored from the backup image, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized.
B. The damaged table space must be restored from the latest backup and any active transaction logs in the log path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database.
C. The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created.
D. The damaged table space will require that the entire database be restored from the latest backup image because the database is non-recoverable and will not be accessible.
Solutions:
| Question #1 Correct Answer: C,D,E | Question #2 Correct Answer: A,C | Question #3 Correct Answer: A,B | Question #4 Correct Answer: C | Question #5 Correct Answer: C |
1253 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
