Use this quick start guide to collect all the information about IBM DB2 Fundamentals for LUW (C2090-616) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the C2090-616 DB2 11.1 Fundamentals for LUW 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 for LUW certification exam.
The IBM DB2 Fundamentals for LUW certification is mainly targeted to those candidates who want to build their career in IBM Data and AI - Platform Analytics domain. The IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of IBM DB2 Fundamentals for LUW.
IBM DB2 Fundamentals for LUW Exam Summary:
| Exam Name | IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows |
| Exam Code | C2090-616 |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Number of Questions | 63 |
| Passing Score | 68% |
| Books / Training | IBM Knowledge Center |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM DB2 Fundamentals for LUW Sample Questions |
| Practice Exam | IBM C2090-616 Certification Practice Exam |
IBM C2090-616 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Planning |
- Identify and describe the DB2 products available - Identify and decribe the DB2 Cloud offerings available - Describe the characteristics of OLTP and Data Warehouse workloads - Describe the benefits of DB2 pureScale - Demonstrate the ability to use DB2 BLU Acceleration - Explain Federation support - Identify and describe Oracle and Netezza Compatibility Features |
21% |
| Security |
- Describe methods used to restrict data access - Identify and describe the authorities and privileges available - Identify and describe the DCL statements available - Describe Roles and Trusted Contexts |
17% |
| Working with Databases and Database Objects |
- Create and connect to DB2 servers and databases - Identify DB2 objects - Identify and describe the DDL statements available - Describe the different types of tables available |
16% |
| Working with DB2 Data using SQL |
- Demonstrate the ability to use SQL to SELECT data from tables - Demonstrate the ability to use SQL to UPDATE, DELETE, or INSERT data - Demonstrate the ability to manage transactions - Demonstrate the ability to create and call an SQL stored procedure or a user defined function - Identify and describe SQL compatibility enhancements - Identify the OLAP function used to meet a specific business requirement |
19% |
| Working with DB2 Tables, Views, and Indexes |
- Identify and describe the DB2 data types available - Identify the characteristics of a table, view or index - Demonstrate the ability to create and use temporary tables - Demonstrate the ability to create and use triggers |
13% |
| Data Concurrency |
- Identify factors that influence locking - List objects on which locks can be obtained - Identify characteristics of DB2 locks - Given a situation, identify the isolation level that should be used |
14% |
To ensure success in IBM DB2 Fundamentals for LUW certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for DB2 11.1 Fundamentals for LUW (C2090-616) exam.