PDF VersionIBM DB2 Fundamentals Exam Certification Details:
| Exam Name | IBM Certified Database Associate - DB2 10.1 Fundamentals |
| Passing Score | 66% |
| Duration | 90 mins |
| Exam Price | $200 (USD) |
| Exam Code | C2090-610 |
| Books / Training | DB2 SQL Workshop DB2 Family Fundamentals |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM DB2 Fundamentals Sample Questions |
| Number of Questions | 69 |
IBM C2090-610 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| 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% |
| 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% |
| 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% |
| 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% |
| 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% |
| 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% |
In a few years, IBM A2090-610 certification exam has become a very influential exam which can test computer skills.The certification of IBM certified engineers can help you to find a better job, so that you can easily become the IT white-collar worker,and get fat salary.
However, how can pass the IBM A2090-610 certification exam simple and smoothly? ITCertMaster can help you solve this problem at any time.
ITCertMaster is a site which providing materials of International IT Certification. ITCertMaster can provide you with the best and latest exam resources.The training questions of IBM certification provided by ITCertMaster are studied by the experienced IT experts who based on past exams. The hit rate of the questions is reached 99.9%, so it can help you pass the exam absolutely. Select ITCertMaster, then you can prepare for your IBM A2090-610 exam at ease.
Our materials of IBM A2090-610 international certification exam is the latest collection of exams' questions, it is covering a comprehensive knowledge points. It is the best assistant for you preparation about the exam. You just need to spend 20-30 hours to remember the content of the questions we provided.
All customers that purchased the materials of IBM A2090-610 exam will receive the service that one year's free update, which can ensure that the materials you have is always up to date. If you do not pass the exam after using our materials, you can provide the scanning items of report card which provided by authorized test centers (Prometric or VUE) . we will refund the cost of the material you purchased after verified, We guarantee you interests absolutely.
Before you select ITCertMaster, you can try the free download that we provide you with some of the exam questions and answers about IBM A2090-610 certification exam. In this way, you can know the reliability of ITCertMaster.
ITCertMaster is the best choice which can help you to pass the IBM certification exams, it will be the best guarantee for your exam.
No matter what level of entry you are for your IBM Certification, you will pass your A2090-610 exam, FAST!
Quickly select ITCertMaster please! Select ITCertMaster is equivalent to choose a success. With it you can complete your dreams quickly!
Easy and convenient way to buy: Just two steps to complete your purchase, we will send the product to your mailbox quickly, you only need to download e-mail attachments to get your products.
Our C2090-610 exam dumps will include those topics:
- Data Concurrency: 13%
- Working with Databases and Database Objects: 20%
- Working with DB2 Data using SQL: 20%
- Planning: 10%
- Security: 15%
- Working with DB2 Tables, Views, and Indexes: 22%
For more info visit:C2090-610 Exam Reference
1059 Customer Reviews
