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

Which two statements are true with regards to nesting SQL procedures? (Choose two.)

A. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java).

B. An SQL procedure can invoke the same SQL procedure more than once.

C. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause.

D. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.

E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.

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.

Which of the following statements is true?

A. A DATETIME value can be assigned to a DATE variable.

B. Values cannot beassigned to variables inside ERROR HANDLERS.

C. A TIMESTAMP value can be assigned to a TIME variable.

D. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.

Given the following procedures:

What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES procedure is called with the value 23 provided as input?

A. 0

B. 6B.6

C. 23C.23

D. 10D.10

When you right-click a SQL procedure in the Data Source Explorer of IBM Data Studio and select Drop from the options menu, what happens?

A. The SQL procedure is temporarily hidden in the Data Source Explorer view.

B. The SQL procedure is removed from the data development project.

C. The SQL procedure is dropped from the database.

D. The SQL procedure is dropped from the database and removed from the data development project.

Which tool can be used to get quick static SQL Explain data from packages?

A. db2expln

B. db2exfmt

C. Control Center

D. DB2 command center

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

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

Which statement is true about the NUMBER data type?

A. In DB2, theNUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.

B. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.

C. Declaring a column as NUMBER(10,-2)is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

D. Declaring a column as NUMBER(6,8) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

Click the Exhibit button.

Referring to the exhibit, which two statements are correct? (Choose two.)

A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.

B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.

C. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.

D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.

E. If the messages table does not exist, the SQL procedure will still compile.