ExamDumpster

C2090-616

DB2 11.1 Fundamentals for LUW practice test

316 IBM C2090-616 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.

Full access

$99

  • All 316 questions, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
IBM logo
Questions
316
Free samples
20
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
Open the full exam guide

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.

Duration
90 min
Questions
63
Passing score
68%
Level
Associate
Question types
Multiple choice, Multiple response

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

C2090-616 questions, answered