C2090-616
DB2 11.1 Fundamentals for LUW practice test
316 IBM C2090-616 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 316 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 316
- Free samples
- –
- Versions
- 1
- Updated
- Sep 2021
Exam simulator
Practice C2090-616 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
C2090-616, by the numbers.
Official specifications published by IBM.
- Duration
- 90 min
- Questions
- 63
- Passing score
- 68%
- Exam fee
- $200

Exam guide
Everything about C2090-616.
C2090-616 · IBM · v1.0
What is C2090-616?
C2090-616 is an entry-level IBM exam on DB2 11.1 for Linux, UNIX and Windows (LUW). Passing it earns the IBM Certified Database Associate credential. It suits new DBAs, developers and system administrators with six months to a year of DB2 use. The exam asks you to plan a DB2 setup, write SQL, build tables and indexes, and control access. In DB2, an authority such as DBADM gives broad rights, while a privilege allows one action on one object, such as reading a table. One typical task is adding a check constraint so a table refuses an order with a negative quantity. Its practice questions focus on planning, SQL, security, database objects and concurrency.
What you'll practise
- Choose DB2 products and features to suit a given workload.
- Control data access with authorities, privileges and DCL statements such as GRANT.
- Create and manage databases, table spaces and other DB2 objects with DDL.
- Write SQL to query and change data, including more advanced SQL features.
- Define tables with the right data types and constraints, and add views and indexes.
- Explain locks, lock management and isolation levels.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: six months to one year of experience with DB2.
- Recommended: basic SQL and an understanding of relational database concepts.
- Recommended: familiarity with Linux, UNIX or Windows.
Who it's for
- New database administrators and developers who work with DB2 on Linux, UNIX or Windows.
- System administrators who look after DB2 servers.
- Database architects and IT staff starting the IBM DB2 certification path.
Exam details
Published by IBM, plus what is in our question bank.
What does C2090-616 cover?
6 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing C2090-616 earns the IBM Certified Database Associate - DB2 11.1 Fundamentals for LUW in the Data and AI track.
How to study for this exam?
Use the C2090-616 practice test alongside the official material and the study plan below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- Jun 15, 2016
- Announced
- Apr 12, 2016
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator