IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 41:

  Given the following CREATE PROCEDURE statement:

  

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

  A. Variables, cursors, and condition handlers

  B. Cursors, variables, condition handlers

  C. Condition handlers, variables, cursors

  D. Condition handlers, cursors, variables

  Correct Answer: A

• Question 42:

  When considering authorization for CREATE OR REPLACE PROCEDURE statements, the authorization id must have:

  A. DBADM authority

  B. group privileges on the table or view specified in the procedure

  C. IMPLICIT_SCHEMA authority on the database

  D. ownership of the existing procedure

  Correct Answer: D

• Question 43:

  Which object is used to return a result set from an SQLprocedure?

  A. Temporary table

  B. Array

  C. Cursor

  D. Scratchpad

  Correct Answer: C

• Question 44:

  Which statement will let you use the result set from the nested procedure CALLEE?

  A. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee;

  B. BIND RESULT SET WITH PARAMETERS FOR PROCEDUREcallee;

  C. INSERT RESULT SET FROM callee INTO CURSOR c1;

  D. SELECT * FROM callee;

  Correct Answer: A

• Question 45:

  Click the Exhibit button.

  

  A trigger was created as shown in the exhibit.

  The UPDATE statement shown below is executed. UPDATE dept SETsales_id = '300' WHERE sales_id = '200'

  How many row(s) are updated in the EMPLOYEE table?

  A. 0

  B. 1

  C. 2

  D. 3

  Correct Answer: B

• Question 46:

  Given the following DDL:

  

  What will the SALARY be?

  A. salary * 1.03

  B. salary * 1.05

  C. salary * 1.10

  D. salary * 1.50

  Correct Answer: D

• Question 47:

  Given the procedure shown below:

  

  How many rows will be inserted in thetable?

  A. 0

  B. 1

  C. 2

  D. 3

  Correct Answer: A

• Question 48:

  Which two statements are true when working with triggers? (Choose two.)

  A. Triggers can be used to enforce data integrity rules.

  B. Triggers can be used with both tables and views.

  C. Triggers can be altered.

  D. Triggers can be used on Materialized Query Tables.

  E. Triggers can be used on Created Temporary Tables.

  Correct Answer: AB

• Question 49:

  Click the Exhibit button.

  

  Given the user-defined function shown in the exhibit, what will the function return if invoked using the statement shown below? SELECT check_id(1) FROMSYSIBM.SYSDUMMY1

  A. Error: ID 1 is not valid

  B. Application Error

  C. SQLSTATE 80000 will be returned, with the custom error message "Error: ID 1 is not valid"

  D. NULL

  Correct Answer: D

• Question 50:

  Which statement will create a scalar function named FCN1?

  A. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)

  B. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

  C. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

  D. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)

  Correct Answer: D