IBM C2090-546 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: High Availability and Recovery | 20% | - HADR and failover - Logging configuration - Backup and restore |
| Topic 2: DB2 9.7 New Features | 17.5% | - PureXML improvements - Compatibility enhancements - Administration automation |
| Topic 3: Monitoring DB2 Activity | 7.5% | - Event monitors - Log and diagnostic analysis - Monitor functions and tables |
| Topic 4: Performance | 17.5% | - Statistics management - Configuration parameters - Index tuning - Query optimization |
| Topic 5: Physical Design | 22.5% | - Table and index design - Data compression - Table spaces and containers - XML storage support |
| Topic 6: Security and Compliance | 15% | - Trusted contexts - Encryption and audit - Authentication and authorization |
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. Which tool can be used to configure High Availability and Disaster Recovery (HADR) in a clustered environment?
A) db2hadmin
B) db2haicu
C) db2hacfg
D) db2ha
2. Which command will enable Oracle applications to work within a DB2 9.7 environment?
A) db2set DB2_COMPATIBILITY=ORACLE
B) db2set DB2_COMPATIBILITY_VECTOR=ORA
C) db2set DB2_COMPATIBILITY=ORA
D) db2set DB2_COMPATIBILITY_VECTOR=ORACLE
3. A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?
A) MON_GET_LOCKS_DETAILS
B) MON_GET_WORKLOAD_DETAILS
C) MON_GET_WORKLOAD
D) MON_GET_LOCKS
4. Given the following DDL statements:
What is the end result of the CREATE INDEX statement?
A) TBSP11 and TBSP12 will each contain one local index since the local indexes will physically reside in the same table space as the related data.
B) INDEX_TS will contain one non-partitioned index since the create index command is missing the PARTITION keyword.
C) TBSP21 will contain one index because NEW_IDX is not partitioned and will automatically go into the first index partition listed in the create table statement.
D) TBSP21 and TBSP22 will each contain one local index.
5. Which two of the following can now be monitored with DB2 v9.7? (Choose two.)
A) Memory consumption by static and dynamic SQL statements.
B) Deadlocks, lock timeouts, and lock waits.
C) Unit of work total CPU usage.
D) Unit of work total memory usage.
E) Memory consumption by static SQL statements.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: D | Question # 5 Answer: B,C |
1175 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.
