Anyone can claim quality; ExamCost demonstrates it. The free IBM Assessment: DB2 9.7 Application Development demo puts real A2090-543 questions and expert-edited answers in your hands before you spend anything.
IBM A2090-543 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM DB2 9.7 Application Development |
| Exam Number: | A2090-543 |
| Available Languages: | English |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 IBM Certified Application Developer - DB2 |
| Exam Format: | Scenario-based questions, Multiple choice |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM Training - DB2 courses |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | ![]() |
| Exam Way: | Computer-based test (online or test center depending on region) |
| Pre Condition: | No formal prerequisites, but knowledge of SQL and DB2 database concepts is recommended. |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM A2090-543 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| DB2 Fundamentals | - Data types and schema objects
|
| Application Development with DB2 | - Transaction management
|
| SQL and Query Development | - SQL fundamentals
|
| Database Programming | - Stored procedures and triggers
|
| Security and Administration Basics | - Authorization and privileges
|
| Performance and Optimization | - Database performance tuning
|
FAQ for IBM Assessment: DB2 9.7 Application Development Candidates
IBM Assessment: DB2 9.7 Application Development is an official IBM exam, catalogued under the code A2090-543. A pass awards you the IBM Certified Application Developer - DB2 9.7 certification at the Professional level. It also supports progress toward IBM Certified Database Administrator - DB2 9.7, IBM Certified Application Developer - DB2. Demand for this credential has stayed strong because it validates skills employers can use from day one.
No formal prerequisites, but knowledge of SQL and DB2 database concepts is recommended.
Vendor policies shift over time, so confirm the current entry conditions before paying any registration fee; the official exam page is the authoritative source.
You can sign up for IBM Assessment: DB2 9.7 Application Development through the official registration points listed here.
Regarding format, the exam is delivered Computer-based test (online or test center depending on region).
IBM recommends the following training for IBM Assessment: DB2 9.7 Application Development candidates.
Course content builds understanding, but the exam grades answers. Bridge the two with the 100 practice questions in the ExamCost A2090-543 package, and the theory starts converting into points.
Yes. A free demo of the IBM Assessment: DB2 9.7 Application Development material is available on this page, so you can verify the quality of the questions and the expert-edited answers yourself. Once you purchase, updates are free for 365 days and the newest version is emailed to you automatically as it releases; after expiry, extending the update service costs 50% of the regular price.
A 100% money-back guarantee covers your purchase under defined conditions. If you take the IBM Assessment: DB2 9.7 Application Development exam within 60 days of buying and fail, you can claim a full refund, provided the exam matches your product. Attempts within 3 days of purchase are ineligible, as are downloaded-but-unused products, free materials, and expired orders, and the candidate name must match the payer name. Submit a scanned enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, you may exchange rather than refund: two other exam products of equal value, free, with the update service on your original purchase kept intact.
Delivery is instant: files unlock for download upon successful payment and are automatically emailed to you within one minute. If nothing arrives within 2 hours, check spam and contact us by email or online service. Installation is unlimited across your computers.
IBM Assessment: DB2 9.7 Application Development spans 6 official domains. The most heavily weighted include DB2 Fundamentals, Database Programming, and Security and Administration Basics. The full topic list is published above on this page; let the weightings decide where your next study hour goes.
IBM Assessment: DB2 9.7 Application Development Sample Questions:
Click the Exhibit button.
CREATE TABLE prod_type (prod_type VARCHAR(10), description VARCHAR (30));
CREATE TABLE prod_descr(info XML);
INSERT INTO prod_descr VALUES
('<product id="1">
<name>Orange juice</name>
<company>Orange Garden</company>
<type>Drinks</type>
</product>'),
('<product id="2">
<name>Coke</name>
<company>Best drinks</company>
<type>Drinks</type>
<type>Premium</type>
</product>');
INSERT INTO prod_type VALUES ('Drinks','Drinks');
You execute the SQL statement shown in the exhibit.
Which two statements will return rows? (Choose two.)
- A. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
XMLEXISTS('$INFO/product[type = $PROD_TYPE]'); - B. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product[type=$PROD_TYPE]'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
); - C. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
type VARCHAR(10) PATH './type',
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
type=prod_type; - D. SELECT name, company, description FROM
prod_type, prod_descr, XMLTABLE(
'$INFO/product'
COLUMNS
name VARCHAR(20) PATH './name',
company VARCHAR(20) PATH './company'
)
WHERE
prod_type= XMLCAST (XMLQUERY('$INFO/product/type') AS VARCHAR(10));
Correct Answer: A,B 🗳️
.While developing a CLI application, you use the code shown below:
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
cliRC= SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_ON )
cliRC= SQLPrepare(hstmt, stmt, SQL_NTS);
Now, the ORG table does not exist in the database.
What will be the value of "cliRC" after executing the SQLPrepare command?
- A. SQL_ERROR
- B. SQL_SUCCESS
- C. SQL_INVALID_HANDLE
- D. SQL_SUCCESS_WITH_INFO
Correct Answer: B 🗳️
The table shown below contains a large number of financial transactions: CREATE TABLE webstore.transactions (transaction_id INTEGER NOT NULL PRIMARY KEY, order_date TIMESTAMP NOT NULL, shipped_date TIMESTAMP, customer_id INTEGER NOT NULL, shipping_info XML NOT NULL, billing_info XML NOT NULL, invoice XML NOT NULL ) Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted from seeing any shipping or billing information. Which database object can a member of the AUDIT_TEAM group create to enable the INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?
- A. view
- B. sequence
- C. alias
- D. trigger
Correct Answer: A 🗳️
Which return codes will be returned by SQLFetch() when there are no more records to be retrieved in a result data set?
- A. SQL_SUCCESS
- B. SQL_NO_MORE_DATA
- C. SQL_WARNING
- D. SQL_NO_DATA_FOUND
Correct Answer: D 🗳️
In a PHP script, which ibm_db2 functions can be used to retrieve the result set of a query executed against a database table?
- A. db2_execute()
- B. db2_fetch_array()
- C. db2_next_result()
- D. db2_result()
Correct Answer: B 🗳️
Viewing page 1 out of 20 pages.
Viewing questions 1-5 out of 100 questions.






