Assessment-DB2-9-5-SQL-Procedure-Developer-Assessment-(A2090-735).pdf

This preview shows page 1 - 3 out of 6 pages.

A2090-735IBMAssessment- DB2 9.5 SQL Procedure Developer-Assessment
QUESTION:92Click the Exhibit button.***MISSING EXHIBIT***CREATE PROCEDURE proc.conv_temp(IN o_temp REAL, IN conv CHAR(3),OUT n_temp REAL) DYNAMIC RESULT SETS 0 CONTAINS SQL LANGUAGE SQLBEGINDECLARE temp_value REAL; IF conv = 'F-C' THENSET temp_value = (o_temp - 32); SET n_temp = (5 * temp_value) / 9; ELSEIF conv = 'C-F'THENSET temp_value = (9 * o_temp) / 5; SET n_temp = (temp_value + 32); END IF;ENDAn SQL procedure was created using thestatement shown in the exhibit.What is the correctway to invoke this procedure from the DB2 Command Line Processor?C
QUESTION:93Click the Exhibit button.***MISSING EXHIBIT***CREATE PROCEDURE proc.conv_temp(IN o_temp REAL, IN conv CHAR(3),INOUT n_temp REAL) DYNAMIC RESULT SETS 0 CONTAINS SQL LANGUAGE SQLBEGINDECLARE temp_value REAL; IF conv = 'F-C' THENSET temp_value = (o_temp - 32);SET n_temp = (5 * temp_value) / 9; ELSEIF conv = 'C-F' THENSET temp_value = (9 * o_temp) / 5; SET n_temp =(temp_value + 32); END IF;ENDAn SQL procedure was created using the statement shown in the exhibit. What is the correct

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
A FULLNAME

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture