A2090-611 Exam Dumps
IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows A2090-611 real exam questions and online practice test engine by FreeCram. Try A2090-611 exam questions for free. You can also download a free demo of the A2090-611 exam PDF version.
IBM's A2090-611 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all A2090-611 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows A2090-611 exam premium questions.
| Certification Provider: | IBM |
|---|---|
| Exam Code / Number: | A2090-611 |
| Exam Name: | Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows |
| Exam Questions: | 118 |
| Last Updated: | Jun 22, 2026 |
| Corresponding Certification: | IBM Certified Database Administrator |
(323 Up Votes)IBM C2090-611 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| 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% |
| 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% |
| Connectivity and Networking | -Demonstrate the ability to configure database connectivity -Demonstrate knowledge of DB2 Discovery -Demonstrate knowledge of LDAP | 6.5% |
| Physical Design | -Demonstrate the ability to create a database and manipulate various DB2 objects
-Demonstrate knowledge of partitioning capabilities | 26% |
| 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% |
| 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% |
| 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% |
IBM DB2 DBA for Linux UNIX and Windows Exam Certification Details:
| Number of Questions | 59 |
| Schedule Exam | Pearson VUE |
| Exam Code | C2090-611 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Passing Score | 61% |
| Exam Name | IBM Certified Database Administrator - DB2 10.1 for Linux UNIX and Windows |
| Sample Questions | IBM DB2 DBA for Linux UNIX and Windows Sample Questions |
| 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 |