IBM DB2 Fundamentals Exam Syllabus

DB2 Fundamentals PDF, C2090-610 Dumps, C2090-610 PDF, DB2 Fundamentals VCE, C2090-610 Questions PDF, IBM C2090-610 VCEUse this quick start guide to collect all the information about IBM DB2 Fundamentals (C2090-610) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-610 IBM DB2 10.1 Fundamentals exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual IBM DB2 Fundamentals certification exam.

The IBM DB2 Fundamentals certification is mainly targeted to those candidates who want to build their career in IBM Analytics - Platform Analytics domain. The IBM Certified Database Associate - DB2 10.1 Fundamentals exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM DB2 Fundamentals.

IBM DB2 Fundamentals Exam Summary:

Exam Name IBM Certified Database Associate - DB2 10.1 Fundamentals
Exam Code C2090-610
Exam Price $200 (USD)
Duration 90 mins
Number of Questions 69
Passing Score 66%
Books / Training DB2 SQL Workshop
DB2 Family Fundamentals
Schedule Exam Pearson VUE
Sample Questions IBM DB2 Fundamentals Sample Questions
Practice Exam IBM C2090-610 Certification Practice Exam

IBM C2090-610 Exam Syllabus Topics:

Topic Details Weights
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)
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
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)
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
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
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)

To ensure success in IBM DB2 Fundamentals certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for IBM DB2 10.1 Fundamentals (C2090-610) exam.

Rating: 5 / 5 (18 votes)