PDF Version DemoIBM A2090-545 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | DB2 9.7 SQL Procedure Developer |
| Exam Number: | 000-545 / C2090-545 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Certificate Validity Period: | No expiration (retired exam) |
| Passing Score: | 60% |
| Related Certifications: | IBM Certified Solution Developer - DB2 9.7 Application Developer IBM Certified Database Associate - DB2 9 Fundamentals |
| Exam Format: | Multiple Choice, Multiple Response, Scenario-based |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 60 |
| Available Languages: | English |
| Recommended Training: | IBM DB2 9.7 Certification Roadmap IBM DB2 9.7 SQL Procedural Language Training |
| Exam Registration: | Prometric (historical) |
| Sample Questions: | IBM A2090-545 Sample Questions |
| Exam Way: | In-person at authorized Prometric test centers; retired exam no longer available for registration |
| Pre Condition: | No mandatory prerequisites; recommended to hold DB2 9 Fundamentals (C2090-730) or equivalent experience |
| Official Syllabus URL: | https://public.dhe.ibm.com/software/data/sw-library/education/cert-roadmaps/DB2_LUW_V9.7.pdf |
IBM A2090-545 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Development Tools | 10% | - Development and deployment tools - IBM Data Studio usage |
| Advanced Features & Optimization | 16% | - SQL PL best practices - Performance considerations - DB2 9.7 enhancements - Security and privileges |
| SQL Procedural Language Fundamentals | 30% | - Error handling and diagnostics - Cursors and result sets - Variables, data types, declarations - Control flow statements |
| User-Defined Functions & Triggers | 21% | - Trigger types and activation - Trigger design and restrictions - CREATE FUNCTION syntax - Scalar and table functions |
| SQL Procedures | 23% | - Parameters and return values - Testing, debugging, and deployment - Dynamic SQL - CREATE PROCEDURE syntax - Nested and external procedures |
IBM Assessment: DB2 9.7 SQL Procedure Developer Sample Questions:
1. In the function shown below:
Which statement can be used to invoke the function above?
A) SELECT * FROM TABLE(fcn1('B01'))
B) SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
C) SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
D) SELECT * FROM fcn1('B01')
2. Assuming EMP_ROW and NEW_HIRE have the same user-defined row data type, what is the best way to assign the elements of NEW_HIRE to EMP_ROW?
A) emp_row.all = new_hire.all;
B) emp_row.rowid = new_hire.rowid;
C) SET emp_row.* = new_hire.*;
D) SET emp_row = new_hire;
3. In the stored procedure below:
What will the value of the P_ID parameter be if the procedure is invoked and a value of 2 is specified for the START_VALUE parameter?
A) 1
B) 2
C) 3
D) 4
4. Which declaration is not valid?
A) DECLARE var1 CHAR;
B) DECLARE var1 VARCHAR(20);
C) DECLARE var1 DECIMAL(9,2);
D) DECLARE var1 INTEGER DEFAULT;
5. Click the Exhibit button.
The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?
A) 1
B) 2
C) 3
D) 4
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: C |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
843 Customer Reviews
Quality and ValueITbraindumps 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 ITbraindumps 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 BuyITbraindumps 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.