C2090-735.pdf - IBM C2090-735 DB2 9.5 SQL Procedure Developer http\/killexams.com\/exam-detail\/C2090-735 QUESTION 88 Click the Exhibit button The file

C2090-735.pdf - IBM C2090-735 DB2 9.5 SQL Procedure...

This preview shows page 1 - 4 out of 9 pages.

C2090-735IBMDB2 9.5 SQL Procedure Developer
Background image
QUESTION: 88 Click the Exhibit button. The file myscript.sql (shown in the exhibit) is executed from the CLP using the command: db2 [email protected] -vf myscript.sql What is the expected outcome? A. SQL procedures PROCA and PROCB will be created, but the CALL command will fail. B. SQL procedure PROCA will not be created. C. SQL procedures PROCA and PROCB will be created and the CALL command will succeed. D. SQL procedure PROCB will not be created. Answer: B QUESTION: 89 Click the Exhibit button.Given the SQL procedure shown in the exhibit, what will the value of the P_ID parameter be if the procedure is invoked and a value of 2 is specified for the START_VALUE parameter
Background image
A. 1 B. 2 C. 3 D. 4 Answer: C QUESTION: 90 Which statement will create a scalar function named FCN1? A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) B. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) C. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) Answer: D QUESTION: 91
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '20
  • 5%, 3%, 00000

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture