The IBM DB2 11.1 Fundamentals for LUW exam has a reputation for tripping up even experienced candidates. Working through 65 realistic practice questions from ActualCollection exposes your weak spots before exam day does.
IBM C2090-616 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 11.1 Fundamentals for LUW |
| Exam Number: | C2090-616 |
| Related Certifications: | IBM Certified Database Advanced Administrator - DB2 11.1 for LUW IBM Certified Database Administrator - DB2 11.1 for LUW |
| Real Exam Qty: | 63 |
| Passing Score: | 68% (43 out of 63) |
| Exam Price: | USD 100 - 200 (varies by region) |
| Certificate Validity Period: | Withdrawn, retired effective March 31, 2023 |
| Available Languages: | English, Japanese |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Multiple Response |
| Recommended Training: | IBM DB2 11.1 Fundamentals Training IBM Knowledge Center DB2 11.1 Documentation |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | ![]() |
| Exam Way: | Proctored at Pearson VUE test centers or online proctored |
| Pre Condition: | No formal prerequisites; basic SQL knowledge and familiarity with DB2 environment recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification/c2090-616-db2-111-fundamentals-for-luw |
IBM C2090-616 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Working with Tables, Views and Indexes | 15% | - Create and manage tables and views - Index design and maintenance - Triggers and constraints enforcement |
| Topic 2: Data Concurrency and Locking | 15% | - Locking mechanisms and isolation levels - Transaction management - Avoiding lock contention and deadlocks |
| Topic 3: Working with DB2 Data using SQL | 20% | - DML, DDL, DCL statements - OLAP and compatibility features - Joins, subqueries, functions |
| Topic 4: Planning | 15% | - DB2 product editions and components - DB2 architecture and instances - Workload types: OLTP vs Data Warehouse |
| Topic 5: Working with Databases and Database Objects | 20% | - Create and connect to databases - Data types, constraints, schemas - Storage groups, table spaces, buffer pools |
| Topic 6: Security | 15% | - Row and column access control - Authentication and authorization - Privileges and authorities |
Common Questions About the IBM DB2 11.1 Fundamentals for LUW Exam
The IBM DB2 11.1 Fundamentals for LUW exam is the official IBM test registered under exam code C2090-616. Passing it earns you the IBM Certified Database Associate - DB2 11.1 for Linux, UNIX and Windows certification, a credential at the Associate level. It is also linked to the related certifications: IBM Certified Database Administrator - DB2 11.1 for LUW, IBM Certified Database Advanced Administrator - DB2 11.1 for LUW. IBM exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The IBM DB2 11.1 Fundamentals for LUW exam includes 63 questions to be completed within 90 minutes. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the IBM DB2 11.1 Fundamentals for LUW exam you need 68% (43 out of 63), and the official registration fee is USD 100 - 200 (varies by region). A retake is not discounted: a failed attempt means paying the full USD 100 - 200 (varies by region) again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
No formal prerequisites; basic SQL knowledge and familiarity with DB2 environment recommended
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Registration for the IBM DB2 11.1 Fundamentals for LUW exam goes through the official channels below.
As for the delivery format, the exam is taken Proctored at Pearson VUE test centers or online proctored.
IBM points candidates toward the following training options for IBM DB2 11.1 Fundamentals for LUW.
Course work builds the foundation; question practice makes it stick. The 65 practice questions in the ActualCollection C2090-616 package let you rehearse each topic under exam-style pressure before the real thing.
Yes. ActualCollection offers a free PDF demo of the IBM DB2 11.1 Fundamentals for LUW material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the IBM DB2 11.1 Fundamentals for LUW exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and emailed to you within one minute of payment. If nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you may install the software on.
The official IBM DB2 11.1 Fundamentals for LUW syllabus is organized into 6 domains. Key areas include Planning (15%), Data Concurrency and Locking (15%), and Working with Tables, Views and Indexes (15%). The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
IBM DB2 11.1 Fundamentals for LUW Sample Questions:
Question 1
If you are already connected to a database, what does running the following statement do?
Db2 CONNECT
A. Returns an error, because you provided no database or alias
B. Prompts you for the authentication information
C. Prompts you for the database name or alias
D. Returns information about the current server
Question 2
DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)
A. Netezza
B. Sybase
C. Microsoft SQL Server
D. Oracle
E. MongoDB
Question 3
Which database object can be locked explicitly?
A. Table
B. View
C. Row
D. Index
Question 4
Which of the following set operators can be used to find all rows that are common in 2 queries?
A. EXCEPT ALL
B. INTERSECT ALL
C. UNION ALL
D. UNION
Question 5
Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?
A. dashDB for transactions
B. DB2 on Cloud
C. Cloudant
D. dashDB for analytics
Solutions:
| Question 1 Answer: D | Question 2 Answer: B,D | Question 3 Answer: A | Question 4 Answer: C | Question 5 Answer: B |






982 Customer Reviews
