PDF Version DemoGetcertkey offers C2090-543 exam preparation in three flexible formats: a printable PDF for study anywhere, a desktop test engine for realistic offline practice, and an online test engine that runs in any browser. However you prefer to prepare, the IBM DB2 9.7 Application Development material fits your routine.
IBM C2090-543 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9.7 Application Development |
| Exam Number: | C2090-543 |
| Available Languages: | English |
| Exam Duration: | 90-120 |
| Exam Price: | Varies by region (approximately 200-250 USD equivalent) |
| Certificate Validity Period: | Not formally expiring (legacy certification; subject to IBM certification program updates) |
| Passing Score: | 60-70% |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 IBM Certified Solution Developer - DB2 |
| Real Exam Qty: | 50-70 |
| Exam Format: | Multiple choice, Multiple response |
| Recommended Training: | IBM DB2 9.7 Application Development Training |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: |  |
| Exam Way: | Proctored exam via IBM authorized testing centers or online delivery (depending on availability) |
| Pre Condition: | No strict prerequisites; basic SQL and database knowledge recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM C2090-543 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| SQL and Query Development | - Views and indexing basics - Joins, subqueries, and set operations - Advanced SQL queries |
| Stored Procedures and Performance | - Stored procedure development - Performance tuning considerations - Query optimization basics |
| Application Programming with DB2 | - Embedded SQL in application programs - JDBC and SQLJ usage - Error handling and diagnostics |
| DB2 Fundamentals | - DB2 architecture and components - Data types and SQL fundamentals - Database objects and schema concepts |
| Transaction Management | - Commit and rollback processing - ACID properties - Locking and concurrency control |
| Security and Authorization | - User privileges and roles - Authentication mechanisms |
C2090-543 Exam FAQs for 2026 Candidates
Which certification does the C2090-543 exam lead to?
The C2090-543 exam is the official IBM exam behind the IBM Certified Application Developer - DB2 9.7 certification, validating the skills measured by the IBM DB2 9.7 Application Development credential. It sits at the Professional level of the IBM certification program. It also connects to IBM Certified Database Administrator - DB2 9.7, IBM Certified Solution Developer - DB2, so the knowledge you build here carries over to those tracks as well.
How many questions are on the C2090-543 exam, and how much time do I get?
The C2090-543 exam contains 50-70 questions to be completed within 90-120. 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-543 exam, and what does it cost?
The passing score for the C2090-543 exam is 60-70%, and the official registration fee is Varies by region (approximately 200-250 USD equivalent). 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 100 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-543 exam?
No strict prerequisites; basic SQL and database knowledge recommended 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-543 exam?
You can book the IBM DB2 9.7 Application Development exam through the official registration channels below:
As for delivery, the exam is offered in the following format: Proctored exam via IBM authorized testing centers or online delivery (depending on availability). Choose the option that suits you best when you book your seat.
What official training is recommended for the C2090-543 exam?
IBM recommends the following training resources for the IBM DB2 9.7 Application Development exam:
Official courses build the foundation; the 100 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.
Can I try the C2090-543 practice questions before I buy?
Yes. Getcertkey provides a free C2090-543 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-543 exam, and how is my order delivered?
Every IBM DB2 9.7 Application Development 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-543 exam?
The IBM DB2 9.7 Application Development exam blueprint is organized into 6 domains. The first three are:
- DB2 Fundamentals
- Stored Procedures and Performance
- Application Programming with DB2
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.7 Application Development Sample Questions:
Question 1
What are two valid connection options that you can use while creating a connection in PHP using the IBM_DB2 extension? (Choose two.)
A. "autocommit" => DB2_AUTOCOMMIT_FALSE
B. "CURSOR" => DB2_SCROLLABLE_SENSITIVE
C. "trustedcontext" => DB2_TRUSTED_CONTEXT_ENABLE
D. "DB2_ATTR_CASE" => DB2_CASE_UPPER
Question 2
When creating a trusted connection in CLI/ODBC, it is necessary to set a connection attribute. What is the connection attribute?
A. SQL_ATTR_TRUSTED_CONTEXT_USERID
B. SQL_ATTR_USE_TRUSTED_CONTEXT
C. SQL_ATTR_ENABLE_TRUSTED_CONTEXT
D. SQL_ATTR_TRUSTED_CONTEXT_PASSWORD
Question 3
Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?
A. SELECT * FROMdeptemployees('D11')
B. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
C. SELECT * FROMdeptemployees('D11') AS D11dept
D. SELECT * FROM TABLE(deptemployees('D11'))
Question 4
A CLI/ODBC application uses the SQL FetchScroll() API to retrieve an updatable row set with five rows of data. Each column of the row set is bound to an array of application memory. The API is called with the SQL_FETCH_NEXT FetchOrientationoption and returns SQL_SUCCESS_WITH_INFO. Diagnostics show a truncation SQLSTATE of "01004".
Which API call correctly identifies the record with the failure?
A. SQLGetDiagField( hStmt, SQL_DIAG_ROW_COUNT, &(intVal) );
B. SQLGetDescField( hStmt, SQL_DESC_COUNT, &(intVal) );
C. SQLGetDiagField( hStmt, SQL_DIAG_ROW_NUMBER, &(intVal) );
D. SQLGetDescField( hStmt, SQL_DESC_ARRAY_SIZE, &(intVal) );
Question 5
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE colors (id INT NOT NULL PRIMARY KEY,
descVARCHAR(12));
CREATE TABLE objects(desc VARCHAR(12),
c_idINT REFERENCES colors (id)
ON UPDATE NO ACTION);
INSERT INTO colors VALUES (1, 'Red'), (2, 'Yellow'), (3, 'Blue');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Rain Coat', 2);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
The statement shown below is executed:
UPDATE colors SET id = id - 1;
How many rows will be modified in the COLORS table?
A. 2
B. 3
C. 0
D. 1
Solutions:
| Question 1 Answer: C,D | Question 2 Answer: B | Question 3 Answer: B | Question 4 Answer: C | Question 5 Answer: B |
983 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.