最新的IBM C2090-545免費考試真題

問題1

Click the Exhibit button.

An SQL function was created using the statement shown in the exhibit. Assume this function is invoked by executing the SQL statement shown below:
VALUES e_degree(SMALLINT(17))
What will be returned?

A. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

B. 1
MASTER 1 record(s) selected.

C. 1
BACHELOR 1 record(s) selected.

D. 1
UNKNOWN 1 record(s) selected.

正確答案: D

問題2

Click the Exhibit button.

Which statement is true about the CASE statement shown in the exhibit?

A. All employees will receive at least a 5% salary increase.

B. An employee with a rating of 3 receives no salary increase.

C. An employee with a rating of 2 receives a 3% salary increase.

D. An employee with a rating of 1 receives a 10% salary increase.

正確答案: D

問題3

The cursor BASEINFO was defined as follow:

Which statement would be used to create a local variable named BASEINFOROW that can be used to store results from the BASEINFO cursor?

A. CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo

B. DEFINE ROW baseinforow FOR CURSOR baseinfo

C. DECLARE baseinforow ANCHOR ROW baseinfo

D. DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo

正確答案: C

問題4

In the given text below:

What will be the value of the output variable BONUS?

A. 500

B. 1000

C. 5200

D. 5500

正確答案: A

問題5

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

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

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

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

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

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

正確答案: A,E

問題6

Assuming C1 and C2 are cursor type variables, which of the following operations cannot be performed?

A. SET c1 = CURSOR FOR SELECT * FROM t;

B. IF (c1 = c2) THEN ?END;

C. SET c2 = c1;

D. SET c1 = CURSOR FOR VALUES ('a', 'b', 'c');

正確答案: B

問題7

Which two statements are true about SQL procedures? (Choose 2)

A. SQL procedures cannot be called from triggers.

B. SQL procedures support recursion.

C. SQL procedures support the PRINT statement.

D. SQL procedures reside outside of the database for easy portability.

E. SQL procedures may return multiple result sets to the caller or to a client application.

正確答案: B,E

問題8

Given the following code

What would be value of parm2 if the following proc1 called as call proc1(3, ?)?

A. 8

B. 3

C. 10

D. 0

正確答案: C

最新的IBM DB2 9.7 SQL Procedure Developer - C2090-545免費考試真題

聯系我們

站內鏈接

最新更新