IBM C2090-610 Exam Details & Actual Exam Questions
- Exam Code/Number: C2090-610
- Exam Name/Title: DB2 10.1 Fundamentals
- Certification Provider: IBM
- Corresponding Certification: IBM Certified Application Developer
- Exam Questions: 138
- Updated On: Oct,23 2026
- Certification Level: Associate / Entry Level
IBM DB2 10.1 Fundamentals Exam Questions
View C2090-610 actual exam questions, answers and explanations for free.
91% student found the test questions almost same
All the information you need to pass IBM DB2 10.1 Fundamentals C2090-610 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(65 Up Votes)IBM C2090-610 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Assessment: DB2 10.1 Fundamentals |
| Exam Number: | A2090-610 / C2090-610 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Exam Format: | Multiple Choice, Multiple Select |
| Available Languages: | English, Japanese |
| Related Certifications: | IBM Certified Application Developer - DB2 10.1 for LUW IBM Certified Database Administrator - DB2 10.1 for LUW |
| Real Exam Qty: | 60 - 69 |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | 3 years |
| Passing Score: | 66% |
| Recommended Training: | IBM DB2 10.1 Fundamentals Preparation Guide IBM Official Training for DB2 10.1 |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | IBM C2090-610 Sample Questions |
| Exam Way: | Onsite at Pearson VUE test centers or online proctored |
| Pre Condition: | No formal prerequisites; basic knowledge of SQL and DB2 is recommended |
| Official Syllabus URL: | https://www.ibm.com/certify/tests/ovr610.shtml |
IBM C2090-610 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Working with DB2 Data using SQL | 20% | - Stored procedures and UDFs - Basic and advanced SQL queries - XQuery and XML processing - Transaction management |
| Planning | 10% | - OLTP vs Data Warehousing workloads - Non-relational data types (XML, LOB) - DB2 product editions and features |
| Working with Databases and Database Objects | 20% | - Schemas, tablespaces, buffer pools - DDL statement understanding - Temporal tables and time travel features - Creating and connecting to databases |
| Data Concurrency | 13% | - Locking mechanisms and lock types - Isolation levels including Currently Committed - Factors affecting concurrency |
| Working with DB2 Tables, Views and Indexes | 22% | - Data types including XML and Oracle compatibility types - Schema design and management - Views, indexes, and temporary tables - Constraints, triggers, and referential integrity |
| Security | 15% | - GRANT/REVOKE statements - Privileges and authorities - Roles and trusted contexts - Row and Column Access Control (RCAC) |
0
0
0
10