We're so confident of our products that we provide no hassle product exchange.
IBM A2090-545 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9.7 SQL Procedure Developer |
| Exam Number: | C2090-545 |
| Available Languages: | English |
| Related Certifications: | DB2 9.7 Certification Track (DB2 fundamentals, application developer) IBM Certified Solution Developer - DB2 9.7 SQL Procedure |
| Real Exam Qty: | 55 |
| Exam Format: | Multiple choice |
| Sample Questions: | IBM A2090-545 Sample Questions |
| Exam Way: | Onsite or authorized testing centre delivery |
| Pre Condition: | Typically requires fundamental DB2 SQL knowledge; often taken after or alongside DB2 fundamentals certification. |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ibm-certified-solution-developer-db2-97-sql-procedure-08006102 |
IBM A2090-545 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: SQL Procedure Development | - Dynamic SQL and variable handling - Error handling and condition management - User-defined functions and external routines - Cursor use and result set handling - Stored procedure creation and control flow |
IBM Assessment: DB2 9.7 SQL Procedure Developer Sample Questions:
In the function shown below:
Which statement can be used to invoke the function above?
- A. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
- B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
- C. SELECT * FROM fcn1('B01')
- D. SELECT * FROM TABLE(fcn1('B01'))
Correct Answer: D 🗳️
Click the Exhibit button.
An SQL function was created using the statement shown in the exhibit. Assume this function is invoked by executing the SQL statement shown below:
VALUES e_degree(SMALLINT(17))
What will be returned?
- A. 1
BACHELOR 1 record(s) selected. - B. 1
UNKNOWN 1 record(s) selected. - C. 1
MASTER 1 record(s) selected. - D. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
Correct Answer: B 🗳️
Which statement can be used to define variable that can be shared between procedures?
- A. DECLARE my_gl_var INTEGER DEFAULT 1
- B. CREATE GLOBAL VARIABLE my_gl_var
- C. CREATE OR REPLACE VARIABLE my_gl_var INTEGER
- D. DEFINE GLOBAL VARIABLE my_gl_var INTEGER
Correct Answer: C 🗳️
Using Optimistic Locking, both Transaction 1 and Transaction 2 have read the same row including the RID_BIT and ROW CHANGE TOKEN values. Transaction 1 updates the row after ensuring that the row has not changed after the previous SELECT by adding a RID_BIT and ROW CHANGE TOKEN predicate to the UPDATE statement. Transaction 2 now tries to update that same row using the same predicate as transaction 1. What will be the result?
- A. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 will complete with an insert of a new row.
- B. The row will be found with a different ROW CHANGE TOKEN and Transaction 2 will overwrite the values set in transaction 1.
- C. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 has to retry in order to retrieve the current data.
- D. The row will be found with the same ROW CHANGE TOKEN. Transaction 2 will now insert its values replacing those of transaction 1.
Correct Answer: C 🗳️
Which of the following can be used to assign multiple values to a row data type variable?
- A. A VARIABLE VALUES statement.
- B. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.
- C. A DIRECT ASSIGNMENT statement.
- D. A SELECT * statement, a VALUES * statement, or a FETCH * statement.
Correct Answer: B 🗳️
Viewing page 1 out of 23 pages.
Viewing questions 1-5 out of 115 questions.
By Wilbur
