IBM DB2 DBA for Linux UNIX and Windows Exam Certification Details:
| Exam Code | C2090-611 |
| Number of Questions | 59 |
| Passing Score | 61% |
| Exam Price | $200 (USD) |
| Sample Questions | IBM DB2 DBA for Linux UNIX and Windows Sample Questions |
| Duration | 90 mins |
| Books / Training | DB2 10.5 for LUW New Features and Database Upgrade Considerations DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs |
| Exam Name | IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows |
| Schedule Exam | Pearson VUE |
IBM C2090-611 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Connectivity and Networking | -Demonstrate the ability to configure database connectivity -Demonstrate knowledge of DB2 Discovery -Demonstrate knowledge of LDAP | 6.5% |
| Monitoring DB2 Activity | -Demonstrate the ability to use Admin views and SQL functions for monitoring -Knowledge of Work Load Manager monitoring features -Demonstrate the ability to use additional auto-monitoring tools -Demonstrate the ability to identify the functions of Problem Determination Tools -Demonstrate the ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information | 10% |
| Utilities | -Demonstrate the ability to use traditional data movement utilities -Demonstrate the ability to use the Ingest utility -Demonstrate the ability to use the REORG, REORGCHK, REBIND, RUNSTATS and FLUSH PACKAGE CACHE utilities -Demonstrate the ability to use the DB2 Design Advisor utility | 14% |
| Physical Design | -Demonstrate the ability to create a database and manipulate various DB2 objects
-Demonstrate knowledge of partitioning capabilities | 26% |
| Business Rules Implementation | -Demonstrate the ability to create constraints on tables -Demonstrate the ability to create views WITH CHECK OPTION -Demonstrate the ability to create and using triggers -Demonstrate the ability to use the set integrity command | 8.5% |
| DB2 Server Management | -Demonstrate the ability to configure/manage DB2 servers, instances, and databases -Demonstrate the ability to use autonomic features -Demonstrate the ability to use Data Studio
| 10% |
| Security | -Describe DB2 authorizations and privileges -Knowledge of the security administrator role -Demonstrate general knowledge of the Audit facility -Demonstrate knowledge of the trusted context -Demonstrate knowledge of row column access control (RCAC) -Demonstrate knowledge of LBAC | 15% |
| High Availability | -Describe DB2 data integrity actions (crash recovery, version recovery, roll forward recovery) -Demonstrate the ability to perform database-level and table space level backup and recovery operations -Demonstrate the ability to configure and manage HADR (read from standby) -Demonstrate knowledge of DB2 pureScale (HA features only) | 10% |
1093 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.
