Reputation is earned release by release. PracticeVCE's A2090-730 materials are the product of continuous research and development, updated faster than typical market offerings, and checked answer by answer — which is why the IBM Assessment: DB2 9 Family Fundamentals bank stays trusted in 2026.
IBM A2090-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) |
| Related Certifications: | IBM Certified Database Administrator - DB2 9 IBM Certified Application Developer - DB2 9 IBM Certified Database Administrator - DB2 9 for z/OS |
| Exam Price: | Approx. $200 USD (varies by region) |
| Available Languages: | English |
| Real Exam Qty: | 64 |
| Passing Score: | 590 / 1000 (59%) |
| Exam Format: | Multiple Choice, Linear / Adaptive |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM DB2 9 Fundamentals Certification Study Guide IBM DB2 9 Fundamentals Training |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | DOWNLOAD DEMO |
| 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 A2090-730 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Working with Databases and Database Objects | 17% | - Storage structures: tablespaces, containers - DDL statements: create, alter, drop objects - Schemas, tables, views, nicknames - Instance and database connections |
| Working with DB2 Data using SQL and XQuery | 23.5% | - Joins, subqueries, common table expressions - Sorting, grouping, filtering data - Transactions and concurrency control - DML statements: SELECT, INSERT, UPDATE, DELETE - XML and XQuery basics |
| Planning | 14% | - Non-relational and XML data concepts - DB2 tools and utilities - DB2 product family and editions - Workload types: OLTP, OLAP, Data Warehousing |
| Working with DB2 Tables, Views and Indexes | 23.5% | - Table structure and constraints - Views, materialized query tables - Data integrity and constraints - Index types and usage |
| Security | 11% | - GRANT / REVOKE statements - Access control and authentication - Data and network encryption - Authorities, privileges, roles |
A2090-730 Exam Basics and Our Service Policies
Clear conditions, honored without argument. If you fail the corresponding exam within 60 days of purchase, send a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims are refunded in full within seven days. Excluded from the policy: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. If you prefer, exchange your product for two others of equal value instead.
Download immediately after purchase — no waiting. Upon successful payment, our system sends the A2090-730 materials to your mailbox automatically, usually within about a minute; open the attachments or use the on-screen link and start studying right away. If nothing arrives within two hours, check your spam folder and contact us. Updates are free for 365 days and are released at the quickest speed whenever the actual exam content changes; after the year, renew at a 50% discount.
IBM defines the following prerequisites for the IBM Assessment: DB2 9 Family Fundamentals: No formal prerequisites; recommended basic database knowledge and 6+ months of DB2 experience.
Verify the current requirements on the official certification page before booking.
The current exam information lists 64 questions for the A2090-730 exam, with 90 minutes minutes allowed. Practicing with a timer beforehand turns the limit into a familiar rhythm.
IBM points candidates to these official training options:
Combine structured training with regular question practice for the sturdiest preparation.
Through continuous research and development, and speed. Our technicians and experts work on the A2090-730 bank daily, updating the database the moment the actual exam content changes — more frequently than typical offerings on the market. The bank is organized around the core knowledge and key points of the IBM Assessment: DB2 9 Family Fundamentals syllabus, every answer is expert-verified, and delivery is immediate after payment. Customers come first here, and the free demo lets you verify all of it before spending anything.
The IBM Assessment: DB2 9 Family Fundamentals blueprint is built on these principal domains:
- Planning (14%)
- Working with DB2 Data using SQL and XQuery (23.5%)
- Working with DB2 Tables, Views and Indexes (23.5%)
The official outline continues with additional domains — the question bank covers the full set.
At present, the passing score for the A2090-730 exam is 590 / 1000 (59%) and the registration fee is Approx. $200 USD (varies by region). Both belong to IBM and can change, so confirm them on the official site when you register.
Registration is handled through the official channels listed here:
Select a test center or online appointment, and book early — the most convenient slots fill first.
IBM Assessment: DB2 9 Family Fundamentals Sample Questions:
Which of the following tools can NOT be used to catalog a database?
- A. Command Line Processor
- B. SQL Assist
- C. Configuration Assistant
- D. Control Center
Correct Answer: B 🗳️
If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?
- A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level
- B. If an index is created for the SALES table, its data must be stored in table space TBSP0
- C. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned
- D. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement
Correct Answer: D 🗳️
If the following SQL statements are executed in the order shown:
CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);
INSERT INTO table1 VALUES (123, 456);
UPDATE table1 SET c1 = NULL;
What will be the result of the following statement?
SELECT * FROM table1;
- A. C1 C2
NULL 456 1 record(s) selected. - B. C1 C2
-
456
1 record(s) selected. - C. C1 C2
0 456
1 record(s) selected. - D. C1 C2
123 456
1 record(s) selected.
Correct Answer: B 🗳️
If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY,
make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT,
model VARCHAR(25),
makeid SMALLINT,
CONSTRAINT const1 FOREIGN KEY (makeid)
REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows:
MAKE
MAKEID MAKE
1 Ford 2 Chevrolet 3 Toyota
MODEL
MODELID MODEL MAKEID
1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?
- A. 1
- B. 0
- C. 3
- D. 2
Correct Answer: B 🗳️
Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
- A. DBCLOB
- B. CLOB
- C. BLOB
- D. GRAPHIC
Correct Answer: B 🗳️
Viewing page 1 out of 61 pages.
Viewing questions 1-5 out of 303 questions.
862 Customer Reviews
