C2090-616: DB2 11.1 Fundamentals for LUW

Full Name: DB2 11.1 Fundamentals for LUW

Exam Code: C2090-616

Try Sample Exam »

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 minutes
Number of Questions	63
Passing Score	43 / 63
Training	IBM Knowledge Center
Sample Questions	IBM DB2 Fundamentals for LUW Sample Questions
Practice Exam	IBM C2090-616 Certification Practice Exam

IBM C2090-616 Exam Syllabus Topics:

Topic(Weights)	Details
Planning (21%)	- 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
Security (17%)	- 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
Working with Databases and Database Objects (16%)	- 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
Working with DB2 Data using SQL (19%)	- 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
Working with DB2 Tables, Views, and Indexes (13%)	- 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
Data Concurrency (14%)	- 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