We're so confident of our products that we provide no hassle product exchange.
IBM A2090-545 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM DB2 9.7 SQL Procedure Developer |
| Exam Number: | 000-545 |
| Related Certifications: | IBM Certified Database Associate - DB2 IBM Certified Database Administrator - DB2 |
| Exam Format: | Multiple choice questions |
| Available Languages: | English |
| Sample Questions: | IBM A2090-545 Sample Questions |
| Exam Way: | Proctored exam (historically delivered via Pearson VUE test centers or online proctoring depending on program availability) |
| Pre Condition: | No formal prerequisite, but experience with DB2 and SQL is strongly recommended. |
IBM A2090-545 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Debugging and Performance Considerations | - Troubleshooting SQL procedures - Performance tuning concepts |
| Topic 2: Triggers and Functions | - User-defined functions (UDFs) - Creating and managing triggers |
| Topic 3: SQL Procedures and Stored Procedures | - Procedure control flow and logic - Creating and managing SQL procedures - Error handling and diagnostics |
| Topic 4: SQL PL (SQL Procedural Language) | - Variables, conditions, and loops - Cursors and result sets |
| Topic 5: DB2 SQL Programming | - Data manipulation using SQL - SQL statements and query optimization basics |
IBM Assessment: DB2 9.7 SQL Procedure Developer Sample Questions:
1. If the following SQL statements were executed in the order shown: What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTER procedure?
A) 100, 0
B) 100 , 1
C) 100, 100
D) 123, 123
2. Which action is supported by Data Studio in the SQL procedure lifecycle?
A) Use auto complete SQL statements.
B) Create global temporary tables to use in the SQL procedure.
C) Debug the SQL procedure.
D) Create user-define types in the SQL procedure.
3. Which of the following can be used to assign multiple values to a row data type variable?
A) A SELECT * statement, a VALUES * statement, or a FETCH * statement.
B) A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.
C) A VARIABLE VALUES statement.
D) A DIRECT ASSIGNMENT statement.
4. Which of the following is the simplest way to define a record with fields corresponding to all of the columns that are fetched from a cursor or cursor variable?
A) Using the READ FROM CURSOR attribute
B) Using the %CURSOR attribute
C) Using the VARRAY attribute
D) Using the %ROWTYPE attribute
5. What is correct use of the MODULE?
A) Improving performance of transactions
B) Grouping object definitions together that has a common business purpose
C) Encryption and encapsulation
D) Supporting referential integrity
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: D | Question # 5 Answer: B |
By Taylor
