C2090-545 by IBM Actual Free Exam Questions And Answers

Question 1

Which command can be used to optimize static SQL statements containing parameterized queries?

A. SET CURRENT EXPLAIN MODE=EXPLAIN

B. SET CURRENT EXPLAIN MODE=PARAM

C. SET CURRENT EXPLAIN MODE=YES

D. SET CURRENT EXPLAIN MODE=REOPT

Discussion 0

Correct Answer: D Vote an answer

Question 2

Which declaration is not valid?

A. DECLARE var1 VARCHAR(20);

B. DECLARE var1 CHAR;

C. DECLARE var1 DECIMAL(9,2);

D. DECLARE var1 INTEGER DEFAULT;

Discussion 0

Correct Answer: D Vote an answer

Question 3

In which type of table space must global temporary tables be created?

A. USER TEMPORARY

B. REGULAR

C. LONG

D. SYSTEM TEMPORARY

Discussion 0

Correct Answer: A Vote an answer

Question 4

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 dropped from the database and removed from the data development project.

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 temporarily hidden in the Data Source Explorer view.

Discussion 0

Correct Answer: C Vote an answer

Question 5

What are two ways to execute an SQL procedure using IBM Data Studio? (Choose two.)

A. Right-click on the SQL procedure and select the Open Visual Explain option from the menu.

B. Right-click on the SQL procedure and select the Run option from the menu.

C. Open a text editor, enter the appropriate CALL statement and hit the run button.

D. Open a Command Line Processor window from IBM Data Studio and execute the appropriate CALL statement.

E. Open a SQL editor, enter the appropriate CALL statement and hit the Run button.

Discussion 0

Correct Answer: B,E Vote an answer

Question 6

Click on the Exhibit button.

Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure
is invoked by the call statement shown below?
CALL find_customers(ARRAY[?16-305-3745?
?05-416-4565?
?16-305-3746?
'905-414-4566'],
?16??)

A. [?16-305-3745??05-416-4565? ?16-305-3746']

B. [?05-416-4565? '905-414-4566']

C. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']

D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?

Discussion 0

Correct Answer: D Vote an answer

Question 7

In the stored procedure below:

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?

A. 2

B. 4

C. 3

D. 1

Discussion 0

Correct Answer: C Vote an answer

Question 8

Click the Exhibit button.

If the procedure TEST1 shown in the exhibit is called with the value 'A00' specified for the SOMEID parameter, what is the expected return code?

A. 0

B. -1

C. -2

D. -3

Discussion 0

Correct Answer: A Vote an answer

IBM DB2 9.7 SQL Procedure Developer - C2090-545 Exam Practice Test

Contact Us

Useful Links

Latest Updated