DB2 9.7 Application Development

1. Which condition will prevent a developer from using the DB2 Call Level Interface in an application?

A. The developer must control the cursor names to comply with company naming standards.

B. An SQL precompiler is not available to the developer.

C. The application must create an external scalar function with the CREATE FUNCTION statement.

D. The DECLARE CURSOR statement needs to be used.

Answer: D

We took the IBM DB2 9.7 Application Development 000-543 exam, but when we saw the large quantities of study materials, we became a little anxious. We studied day and light till someday I felt that we could not capture the main points of the real test, so I entered the professional IBM forum to copy others experience.

2. The statement below was used to create a cursor named CSR1: DECLARE csr1 DYNAMIC SCROLL CURSOR FOR SELECT * FROM employee;After fetching all of the rows in the result set associated with cursor CSR1, which two statements can be used to fetch the data starting at the end of the result set? (Choose two.)

A. FETCH LAST

B. FETCH PRIOR

C. FETCH RELATIVE

D. FETCH OFFSET

Answer: BC