000-610 Exam Dumps
IBM DB2 10.1 Fundamentals 000-610 real exam questions and online practice test engine by FreeCram. Try 000-610 exam questions for free. You can also download a free demo of the 000-610 exam PDF version.
IBM's 000-610 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all 000-610 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest IBM DB2 10.1 Fundamentals 000-610 exam premium questions.
| Certification Provider: | IBM |
|---|---|
| Exam Code / Number: | 000-610 |
| Exam Name: | DB2 10.1 Fundamentals |
| Exam Questions: | 138 |
| Last Updated: | Jun 24, 2026 |
| Corresponding Certification: | IBM Certified Application Developer |
This exam has been stopped to register, new exam code replace: C2090-610
How much C2090-610 Exam Cost
The price of the exam is 200 USD.
IBM C2090-610 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Working with Databases and Database Objects | -Ability to create and connect to DB2 servers and databases (requirements to give ability to connect) -Ability to identify DB2 objects -Knowledge of basic characteristics and properties of DB2 objects -Given a DDL SQL statement, knowledge to identify results (ability to create objects) -Knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to create (Greater precision time stamps) | 20% |
| Security | -Knowledge of restricting data access -Knowledge of different privileges and authorities -Given a DCL SQL statement, knowledge to identify results (grant/revoke/connect statements) -Knowledge of Row and Column Access Control (RCAC) -Knowledge of Roles and Trusted Contexts | 15% |
| Data Concurrency | -Knowledge to identify factors that influence locking -Ability to list objects on which locks can be obtained (lock table) -Knowledge to identify characteristics of DB2 locks (common locks shared across platforms) -Given a situation, knowledge to identify the isolation levels that should be used (currently committed) | 13% |
| Working with DB2 Data using SQL | -Ability to use SQL to SELECT data from tables -Ability to use SQL to SORT or GROUP data -Ability to use SQL to UPDATE, DELETE, or INSERT data -Knowledge of transactions (i.e., commit/rollback and transaction boundaries) -Ability to create and call an SQL supported procedure or a user defined function (understanding of passing parameters and results) -Given an XQuery statement, knowledge to identify results -Knowledge of Temporal (Time Travel) Tables - System-period, Application-period, and Bi-temporal - ability to query | 20% |
| Working with DB2 Tables, Views and Indexes | -Ability to demonstrate usage of DB2 data types (XML data types, Oracle compatibility data types) -Given a situation, ability to create a temporary table -Knowledge to identify when referential integrity should be used -Knowledge to identify methods of data constraint -Knowledge to identify characteristics of a table, view or index -Knowledge to identify when triggers should be used -Knowledge of schemas | 22% |
| Planning | -Knowledge of DB2 products (z/OS vs LUW vs pureScale - at a high-level; different products and what they do) -Knowledge of database workloads (appropriate DB2 product to use - OLTP vs warehousing) -Knowledge of non-relational data concepts (XML data, LOB data) | 10% |
Exam Difficulty
When preparing for the C2090-610 certification exam, the real world experience is required to stand a reasonable chance of passing C2090-610 exam. IBM recommended courses does not replace the requirement for experience. So, It is very difficult for the candidate to pass the C2090-610 exam without experience.