IBM DB2 Fundamentals for LUW Exam Syllabus

DB2 Fundamentals for LUW PDF, C2090-616 Dumps, C2090-616 PDF, DB2 Fundamentals for LUW VCE, C2090-616 Questions PDF, IBM C2090-616 VCE, IBM DB2 Fundamentals for LUW Dumps, IBM DB2 Fundamentals for LUW PDFUse 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 43 / 63
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.

Rating: 5 / 5 (26 votes)