PDF Version DemoWalking into the C2090-730 exam unprepared for its pace is a risk you do not need to take. The Getcertkey test engines recreate the pressure of the IBM DB2 9 Family Fundamentals testing environment, so when exam day arrives in 2026, it feels like just another practice session.
IBM C2090-730 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9 Family Fundamentals |
| Exam Number: | 000-730 (replaced by C2090-730) |
| Certificate Validity Period: | Lifetime (no expiration) |
| Available Languages: | English |
| Real Exam Qty: | 64 |
| Exam Duration: | 90 minutes |
| Exam Price: | Approx. $200 USD (varies by region) |
| Related Certifications: | IBM Certified Database Administrator - DB2 9 IBM Certified Database Administrator - DB2 9 for z/OS IBM Certified Application Developer - DB2 9 |
| Exam Format: | Multiple Choice, Linear / Adaptive |
| Passing Score: | 590 / 1000 (59%) |
| Recommended Training: | IBM DB2 9 Fundamentals Training IBM DB2 9 Fundamentals Certification Study Guide |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: |  |
| Exam Way: | In-person at Pearson VUE test centers / Online proctored |
| Pre Condition: | No formal prerequisites; recommended basic database knowledge and 6+ months of DB2 experience |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM C2090-730 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Security | 11% | - Authorities, privileges, roles - GRANT / REVOKE statements - Data and network encryption - Access control and authentication |
| Working with DB2 Tables, Views and Indexes | 23.5% | - Index types and usage - Views, materialized query tables - Table structure and constraints - Data integrity and constraints |
| Working with DB2 Data using SQL and XQuery | 23.5% | - DML statements: SELECT, INSERT, UPDATE, DELETE - Joins, subqueries, common table expressions - Sorting, grouping, filtering data - XML and XQuery basics - Transactions and concurrency control |
| Planning | 14% | - DB2 tools and utilities - Non-relational and XML data concepts - Workload types: OLTP, OLAP, Data Warehousing - DB2 product family and editions |
| Working with Databases and Database Objects | 17% | - Storage structures: tablespaces, containers - Instance and database connections - DDL statements: create, alter, drop objects - Schemas, tables, views, nicknames |
Common Questions About the IBM C2090-730 Exam
What is the IBM DB2 9 Family Fundamentals exam all about?
The C2090-730 exam is the official IBM exam behind the IBM Certified Database Associate - DB2 9 certification, validating the skills measured by the IBM DB2 9 Family Fundamentals credential. It sits at the Associate level of the IBM certification program. It also connects to IBM Certified Database Administrator - DB2 9, IBM Certified Application Developer - DB2 9, IBM Certified Database Administrator - DB2 9 for z/OS, so the knowledge you build here carries over to those tracks as well.
How many questions are on the C2090-730 exam, and how much time do I get?
The C2090-730 exam contains 64 questions to be completed within 90 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.
What score do I need to pass the C2090-730 exam, and what does it cost?
The passing score for the C2090-730 exam is 590 / 1000 (59%), and the official registration fee is Approx. $200 USD (varies by region). Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 303 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.
Are there any prerequisites for the C2090-730 exam?
No formal prerequisites; recommended basic database knowledge and 6+ months of DB2 experience Requirements can change when IBM revises its certification program, so confirm the current eligibility rules on the official exam page before you register.
How do I register for the C2090-730 exam?
You can book the IBM DB2 9 Family Fundamentals exam through the official registration channels below:
As for delivery, the exam is offered in the following format: In-person at Pearson VUE test centers / Online proctored. Choose the option that suits you best when you book your seat.
What official training is recommended for the C2090-730 exam?
IBM recommends the following training resources for the IBM DB2 9 Family Fundamentals exam:
Official courses build the foundation; the 303 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.
Can I try the C2090-730 practice questions before I buy?
Yes. Getcertkey provides a free C2090-730 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if IBM revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.
What if I fail the C2090-730 exam, and how is my order delivered?
Every IBM DB2 9 Family Fundamentals purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.
Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.
What topics are covered in the C2090-730 exam?
The IBM DB2 9 Family Fundamentals exam blueprint is organized into 5 domains. The first three are:
- Security — 11% of the exam
- Working with DB2 Data using SQL and XQuery — 23.5% of the exam
- Planning — 14% of the exam
For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.
IBM DB2 9 Family Fundamentals Sample Questions:
Question #1
Which of the following actions will NOT cause a trigger to be fired?
A. ALTER
B. DELETE
C. INSERT
D. UPDATE
Question #2
Which of the following is true of an index used to support a UNIQUE constraint?
A. It must have the UNIQUE WHERE NOT NULL attribute.
B. It must have the UNIQUE attribute.
C. It must have the UNIQUE and CLUSTER attributes.
D. It cannot be created explicitly by the user.
Question #3
Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
A. DB2Enterprise Server Edition
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Express-C
Question #4
Given the following table:
CURRENT_EMPLOYEES
EMPID INTEGER NOT NULL NAME CHAR(20) SALARY DECIMAL(10,2) PAST_EMPLOYEES
EMPID INTEGER NOT NULL
NAME CHAR(20)
SALARY DECIMAL(10,2)
Assuming both tables contain data, which of the following statements will NOT successfully add
data to table CURRENT_EMPLOYEES?
A. INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)
B. INSERT INTOcurrent_employees (empid) VALUES (10)
C. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
D. INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid = 20
Question #5
Given the following DDL for the PARTS table:
CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));
All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?
A. CREATE UNIQUE INDEXidx_partno ON parts(part_name, part_no ASC)
B. CREATE UNIQUE INDEXidx_partno ON parts(part_name ASC)
C. CREATE UNIQUE INDEXidx_partno ON parts(part_no, part_name ASC)
D. CREATE UNIQUE INDEXidx_partno ON parts(part_no)
Solutions:
| Question #1 Correct Answer: A | Question #2 Correct Answer: B | Question #3 Correct Answer: A | Question #4 Correct Answer: C | Question #5 Correct Answer: D |
724 Customer Reviews
Quality and ValueGetCertKey Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our GetCertKey testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyGetCertKey offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.