[Free] 2017(Nov) EnsurePass Braindumps IBM C2090-545 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2017 Nov IBM Official New Released C2090-545
100% Free Download! 100% Pass Guaranteed!

DB2 9.7 SQL Procedure Developer

Question No: 31 – (Topic 2)

Which two statements describe a CASE statement? (Choose two.)

  1. CASE statements are used to enter into some logic based on a literal value.

  2. CASE statements are used to enter into some logicbased on the value of an expression.

  3. CASE statements are used to return control to the beginning of an expression.

  4. CASE statements are used to enter into some condition and loop until the condition is met.

  5. CASE statements are used to iterate intosome logic based on a literal value.

Answer: A,B

Question No: 32 – (Topic 2)


Which of the following steps are required to debug a stored procedure using IBM Data Studio?

  1. Deploy the stored procedure from the data development project, debug the stored procedure.

  2. Debug the stored procedure from the Data Source Explorer.

  3. Deploy the stored procedure from the data development project, choose option for debugging and then debug.

  4. Debug the stored procedure from the IBM Data Studio command line console.

Answer: C

Question No: 33 – (Topic 2)

Click the Exhibit button.

Ensurepass 2017 PDF and VCE

Given the user-defined function shown in the exhibit, what will the function return if invoked using the statement shown below?


  1. Error: ID 1 is not valid

  2. Application Error

  3. SQLSTATE 80000 will be returned, with the custom error message quot;Error: ID 1 is not validquot;

  4. NULL

Answer: D

Question No: 34 – (Topic 2)

Which two types of storedprocedures can be developed in IBM Data Studio? (Choose two.)

  1. SQL

  2. PHP

  3. PL/SQL

  4. Perl

  5. Ruby

Answer: A,C

Question No: 35 – (Topic 2)

Which two statements are true about SQL procedures? (Choose 2)

  1. SQL procedures reside outside of the database for easy portability.

  2. SQL procedurescannot be called from triggers.

  3. SQL procedures may return multiple result sets to the caller or to a client application.

  4. SQL procedures support recursion.

  5. SQL procedures support the PRINT statement.

Answer: C,D

Question No: 36 – (Topic 2)

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

  1. SET rows_fetched = curEmp%CURSOR_ROWCOUNT

  2. SET rows_fetched = curEmp%ROWCOUNT

  3. SET rows_fetched =CURSOR_ROWCOUNT(curemp)

  4. SET rows_fetched = ROWCOUNT(curemp)

Answer: C

Question No: 37 – (Topic 2)

Given the SQL statement shown below:

Ensurepass 2017 PDF and VCE

Which statement correctly describesthe cursor MY_CURSOR?

  1. The cursor does not have sensitivity to insert, update, or delete operations that are made to rows in the underlying result table.

  2. The cursor will not be closed as a consequence of a commit operation.

  3. The result table of the cursor is intended to be used as a result set that will be returned from a procedure.

  4. The cursor can be used to perform positioned delete operations.

Answer: D

Question No: 38 – (Topic 2)

Given the procedure show below:

Ensurepass 2017 PDF and VCE

What will be the value of P2?

  1. 50

  2. 51 C. 100 D. 102

Answer: C

Question No: 39 – (Topic 2)

Given the following CREATE PROCEDURE statement:

Ensurepass 2017 PDF and VCE

In what order must declarations occur within the lines ap: BEGIN and END ap?

  1. Variables, cursors, and condition handlers

  2. Cursors, variables, condition handlers

  3. Condition handlers, variables, cursors

  4. Condition handlers, cursors, variables

Answer: A

Question No: 40 – (Topic 2)

If the following SQL statements were executed in the order shown:

Ensurepass 2017 PDF and VCE

What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTERprocedure?

A. 100, 100

B. 100 , 1

C. 123, 123

D. 100, 0

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-545 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-545 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE