IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Given the following statements: In the above given procedure, the statement in which line is not valid?

A. 7 B. 9 C. 10 D. 1

Discussion 0

Correct Answer: A Vote an answer

Question 2

Given the statement shown below:

What happens to NEWPROD if 'http://posample.org/product.xsd' is dropped?

A. NEWPROD is marked as inoperative. B. NEWPROD is dropped. C. NEWPROD will validate against a new schema. D. NEWPROD will raise an exception.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which of the following statements is true for declared global temporary tables(DGTT)?

A. The DGTT must be stored in a system temporary table space B. SESSION is the implicit schema name of the DGTT C. The data in a DGTT cannot be compressed. D. The value of the USER special register is the implicit schema name of the DGTT

Discussion 0

Correct Answer: B Vote an answer

Question 4

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. 3 B. 2 C. 1 D. 4

Discussion 0

Correct Answer: A Vote an answer

Question 5

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. 1
MASTER 1 record(s) selected. B. 1
UNKNOWN 1 record(s) selected. C. 1
BACHELOR 1 record(s) selected. D. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

Discussion 0

Correct Answer: B Vote an answer

Question 6

What is correct use of the MODULE?

A. Supporting referential integrity B. Improving performance of transactions C. Grouping object definitions together that has a common business purpose D. Encryption and encapsulation

Discussion 0

Correct Answer: C Vote an answer

Question 7

Given the following CREATE PROCEDURE statement: In what order must declarations occur within the lines ap: BEGIN and END ap?

A. Condition handlers, cursors, variables B. Cursors, variables, condition handlers C. Condition handlers, variables, cursors D. Variables, cursors, and condition handlers

Discussion 0

Correct Answer: D Vote an answer

Question 8

In the code segment shown below: Which statement accurately describes the result?

A. The statement will fail since MERGE is not a supported operator. 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 table both have ACTIVITY as a primary key. C. 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. D. 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.

Discussion 0

Correct Answer: B Vote an answer

Question 9

Click the Exhibit button.

How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?

A. 7 B. 5 C. 0 D. 4

Discussion 0

Correct Answer: D Vote an answer