Free IBM 000-545 Exam Dumps Questions & Answers

Which of the following statement is TRUE about a REPEAT loop?

• A.A REPEAT loop behaves like a FOR loop.
• B.A REPEAT loop behaves like a WHILE loop.
• C.The condition is checked at the end of the loop.
• D.The condition is checked at the beginning of the loop.

In a SQL Procedure, rows_fetched is an integer variable and curEmp is a cursor variable of SELECT statement on a table. After opening the cursor curemp, which of the statement will determine the number of rows fetched?

• A.SET rows_fetched = ROWCOUNT(curemp)
• B.SET rows_fetched = curEmp%CURSOR_ROWCOUNT
• C.SET rows_fetched = CURSOR_ROWCOUNT(curemp)
• D.SET rows_fetched = curEmp%ROWCOUNT

What is the correct order for declarations in a compound statement defined by BEGIN and END?

• A.variable, condition, cursor, handler
• B.variable, cursor, condition, handler
• C.variable, cursor, handler, condition
• D.variable, condition, handler, cursor

Given the following SQL:

Which statement is incorrect?

• A.The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
• B.The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
• C.The cursor declaration requires the WITH RETURN clause in order to return a result set.
• D.The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.

When you right-click a SQL procedure in the Data Source Explorer of IBM Data Studio and select Drop from the options menu, what happens?

• A.The SQL procedure is dropped from the database and removed from the data development project.
• B.The SQL procedure is temporarily hidden in the Data Source Explorer view.
• C.The SQL procedure is dropped from the database.
• D.The SQL procedure is removed from the data development project.