IBM Certified Database Associate - DB2 10.5 Fundamentals for LUW (C2090-615: DB2 10.5 Fundamentals for LUW)


comp name

This DB2 associate certification is entry level certification in Db2 family, and this certification is for those who are intrested to start their career as database administrator in IBM DB2 Products in Linux, Unix and Windows Platforms. In This certification, candidates will be tested in fundamentals of db2 10.5 fundamentals like db creation and administration, day to day operations, basic sql knowledge and understanding of basic level db security in Linux,Unix, Windows Opetating Systems .
To achieve this certification, candidates should pass C2090-615: DB2 10.5 Fundamentals for LUW. Find the complete details of certification below.

Exam Details

Required Exam(s) C2090-615: DB2 10.5 Fundamentals for LUW
Durations 90 mins
Passing Score 62 Questions and required passing score is 61%.
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees 100 USD
Prerequired Exams There is no prerequired Exams to take, but its recommended, the candidates must have a basic knowledge of SQL and some hands on experience in DB2 10
Exam Policy Click here to read the Exam policies.
Recommended Training DB2 Family Fundamentals

Exam Pattern

Below the exam objectives of C2090-615: DB2 10.5 Fundamentals for LUW.

Section 1 - Planning (16%)
  • 1.1 Knowledge of DB2 products (DB2 for LUW Editions and DB2 for z/OS ? at a high level; when/why would you use each?)
  • 1.2 Knowledge of database workloads (OLTP vs. Data Warehouse; what is the appropriate product to use for each?)
  • 1.3 Knowledge of DB2 10.5 BLU Acceleration (i.e., the ability to configure a DB2 database for analytics, when BLU Acceleration should be used)
  • 1.4 Knowledge of Oracle Compatibility Features
Section 2 - Security (18%)
  • 2.1 Knowledge of restricting data access (authorities and privileges vs. views vs. RCAC vs. LBAC � at a high level; when is it appropriate to use each?)
  • 2.2 Knowledge of different authorities and privileges
  • 2.3 Given a DCL SQL statement, knowledge to identify results (GRANT/REVOKE/CONNECT statements)
  • 2.4 Knowledge of Row and Column Access Control (RCAC)
Section 3 - Working with Databases and Database Objects (16%)
  • 3.1 Ability to create and connect to DB2 servers and databases (requirements to give ability to connect)
  • 3.2 Ability to identify DB2 objects
  • 3.3 Knowledge of basic characteristics and properties of DB2 objects
  • 3.4 Given a DDL SQL statement, knowledge to identify results (ability to create objects)
  • 3.5 Knowledge of different types of tables available (Base vs. MDC vs. ITC vs. RCT vs. MQT vs. Partitioned vs. Temporal � at a high level; when is it appropriate to use each type?)
Section 4 - Working with DB2 Data Using SQL and Xquery (23%)
  • 4.1 Ability to use SQL to SELECT data from tables
  • 4.2 Ability to use SQL to UPDATE, DELETE, or INSERT data
  • 4.3 Knowledge of transaction management (COMMIT, ROLLBACK, AUTOCOMMIT and SAVEPOINTs)
  • 4.4 Ability to create and call an SQL supported procedure or a user defined function (understanding of passing parameters and obtaining results)
  • 4.5 Knowledge of SQL compatibility enhancements
  • 4.6 Given an XQuery statement, knowledge to identify results
Section 5 - Working with DB2 Tables, Views, and Indexes (13%)
  • 5.1 Ability to demonstrate usage of DB2 data types (XML data types, Oracle compatibility data types)
  • 5.2 Knowledge to identify characteristics of a table, view or index
  • 5.3 Knowledge of temporary tables (how they are created and when they should be used)
  • 5.4 Knowledge of triggers (how they function; when they might be used)
Section 6 - Data Concurrency (15%)
  • 6.1 Knowledge to identify factors that influence locking
  • 6.2 Ability to list objects on which locks can be obtained (LOCK TABLE statement)
  • 6.3 Knowledge to identify characteristics of DB2 locks (common locks shared across platforms)
  • 6.4 Given a situation, knowledge to identify the isolation levels that should be used (currently committed)

Books to Prepare

Below are the recommended books to prepare for C2090-615: DB2 10.5 Fundamentals for LUW.

Ibm book Cover Image

Book Name : DB2 10.5 Fundamentals for LUW (Exam 615)

Author Name : Roger E. Sanders

Publisher : MC Press

Topics Covered in this book:


  • Chapter 1 : IBM DB2 for Linux, UNIX, and Windows Certification
  • Chapter 2 : Planning
  • Chapter 3 : Security
  • Chapter 4 : Working with Databases and Database Objects
  • Chapter 5 : Working with DB2 Data Using SQL and XQuery
  • Chapter 6 : Working with DB2 Tables, Views, and Indexes
  • Chapter 7 : Data Concurrency

Softwares for Practice

You can practice your exams by using below tools

Software Name : IBM DB2 10.5

License : Trail Version

Click here for trail download