Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by IBM
Exam Format
90 min
63
68%
Associate
Registration
$200 USD
Pearson VUE or online proctoring
English, Japanese
Validity
No expiration
No recertification required; Upgrade to higher level certification recommended
C2090-616 Exam Topics and Domains
C2090-616 is organized into 6 weighted domains. Expect to work with DB2 Security, DB2 Lock Manager, BLU Acceleration, DB2, and more.
1
Planning
21%
DB2 Product and Offering Knowledge
DB2 Product OfferingsDB2 Cloud Offerings
- Identify and describe the DB2 products available
- Identify and describe the DB2 Cloud offerings available
- Select appropriate DB2 offering for specific scenarios
Workload Knowledge
OLTP and Data Warehouse Workloads
- Describe the characteristics of OLTP and Data Warehouse workloads
- Identify appropriate DB2 features for different workload types
Advanced DB2 Features
DB2 pureScaleBLU AccelerationFederation and Compatibility
- Identify and describe DB2 pureScale benefits
- Demonstrate the ability to use DB2 BLU Acceleration
- Identify and describe Oracle and Netezza Compatibility Features
2
Security
17%
Data Access Control
Data Access Restrictions
- Given a scenario, identify the method used to restrict data access
- Implement Row and Column Access Control
Authorities and Privileges
Database AuthoritiesObject Privileges
- Identify and describe the authorities and privileges available
- Given a scenario, identify the appropriate authority or privilege
DCL and Security Objects
DCL StatementsRoles and Trusted Contexts
- Identify and describe the DCL statements available
- Given a scenario, identify the roles and trusted contexts to use
3
Working with Databases and Database Objects
16%
Database Creation and Management
Creating and Connecting to DB2 ServersDatabase Connectivity
- Identify the steps required to create and connect to DB2 servers and databases
- Understand database configuration and management
DB2 Objects
Database Object Types
- Identify and describe DB2 objects
- Understand object relationships and dependencies
DDL Statements and Table Management
DDL StatementsTable Types
- Identify and describe the DDL statements available
- Identify and describe the different table types available
4
Working with DB2 Data using SQL
19%
SQL Data Manipulation
DML StatementsTransaction Management
- Demonstrate the ability to use SQL to SELECT, INSERT, UPDATE, or DELETE data
- Demonstrate the ability to manage transactions
Advanced SQL Features
Stored Procedures and FunctionsSQL Compatibility EnhancementsOLAP Functions
- Identify the OLAP function used to meet a specific business requirement
- Demonstrate the ability to create and call stored procedures or UDFs
- Identify when to use SQL compatibility enhancements
5
Working with DB2 Tables, Views and Indexes
13%
Data Types and Constraints
DB2 Data TypesTable Constraints
- Identify and describe the DB2 data types available
- Choose appropriate constraints for data integrity
Views and Indexes
View ManagementIndex Management
- Identify and describe the characteristics of views and indexes
- Demonstrate the ability to create and use indexes for performance
Advanced Table Features
Temporary TablesTriggers
- Demonstrate the ability to create and use temporary tables
- Demonstrate the ability to create and use triggers
6
Data Concurrency
14%
Locking Mechanisms
Factors Influencing LockingLockable Objects
- Identify factors that influence locking
- List objects that locks can be obtained on
Lock Management
Lock CharacteristicsDeadlock Management
- Identify characteristics of DB2 locks
- Understand deadlock detection and resolution
Isolation Levels
Transaction IsolationConcurrency Issues
- Given a situation, identify the isolation level that should be used
- Understand concurrency phenomena and their prevention
How do I earn this certification?
Passing C2090-616 earns the IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW certification. It sits in the Data and AI track.
Next Level Options
- C2090-600 - IBM DB2 11.1 DBA for LUW
- CCIE Lab - Advanced DB2 Administration
Alternative Paths
- C1000-078 - IBM Db2 12 for z/OS DBA FundamentalsMainframe DB2 skills
- C1000-083 - Foundations of IBM Cloud V2Cloud database deployment skills
- Various - IBM DataStage ETL and data integration skills
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
Use the official PlanetCert Practice Test alongside the study plan below to prepare efficiently for C2090-616.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2016-06-15
- Announcement date: 2016-04-12
Updates
- BLU Acceleration 11.1 Core topic in exam - column-organized tables • Release date: 2016-04-12
- pureScale 11.1 High availability and clustering topic • Release date: 2016-04-12
- Oracle Compatibility Enhanced in 11.1 Migration and compatibility features • Release date: 2016-04-12
Who should take this exam?
This exam is typically taken by Database Administrators and System Administrators.
- Six months to one year of experience with DB2
- Basic knowledge of SQL
- Understanding of relational database concepts
- Familiarity with Linux/UNIX/Windows operating systems