C2090-545 Online Practice Questions and Answers

In the function shown below:

Which statement can be used to invoke the function above?

A. SELECT * FROM TABLE(fcn1('B01'))

B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1

C. SELECT * FROM fcn1('B01')

D. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1

Click the Exhibit button.

A user-defined function was created using the statement shown in the exhibit.

Which additional option can be added to the CREATE FUNCTION statement to tell the optimizer that the function doesnot always return the same results for a given argument value?

A. NO EXTERNAL ACTION

B. NOT FENCED

C. NOT DETERMINISTIC

D. STATIC DISPATCH

What is a reason to use SQL procedures in DB2?

A. to use different programming languages

B. to reduce code sharing

C. to move business logic rules into the database

D. to eliminate the need for testing

Which statement is TRUE about associative arrays?

A. Associative array values can be stored in table columns.

B. The index values for an associative array must be a continuous set of integer values.

C. Associative array cannot be atype of a table column.

D. The index data type for an associated array must be an integer.

In thegiven text below: What will be the value of the output variable BONUS?

A. 500

B. 1000

C. 5200

D. 5500

Click the Exhibit button.

The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?

A. 1

B. 2

C. 3

D. 4

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

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;

Which two statements are true? (Choose two.)

A. SQL procedures can contain static and/or dynamic SQL statements.

B. Static or dynamic SQL execution is not associated with a package.

C. The SQL procedure isalways associated with a package that contains access paths of SQL statements in the procedure.

D. It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.

E. SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.

In the code segment shown below:

Which statement accurately describes the result?

A. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.

B. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES tableboth have ACTIVITY as a primary key.

C. For activities whose description has changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.

D. The statement will fail since MERGE is not a supported operator.