C2090-545 Online Practice Questions and Answers

Which statement is permitted within a scalar user-defined function body?

A. COMMIT

B. INSERT

C. SIGNAL

D. LOOP

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

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. DEFINE ROW baseinforow FOR CURSOR baseinfo

B. DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo

C. DECLARE baseinforow ANCHOR ROW baseinfo

D. CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo

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

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

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

C. Open a Command Line Processorwindow from IBM Data Studio and execute the appropriate CALL statement.

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

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

Given the SQL statement shown below:

Which privilege allows a user to execute the CREATE TRIGGER statement shown?

A. SYSCTRL authority

B. SELECT and UPDATE privilege on the EMPLOYEE table

C. SYSMAINTauthority

D. SELECT and ALTER privilege on the EMPLOYEE table

Given the following DDL:

What will the SALARY be?

A. salary * 1.03

B. salary * 1.05

C. salary * 1.10

D. salary * 1.50

Given that CREATEMODULE salesModule statement has been successfully executed, what is the correct method to manage this MODULE?

A. REPLACE MODULE salesModule

B. UPDATE salesModule MODULE FOR

C. ALTER MODULE salesModule

D. CREATE OR REPLACE selesModule UPDATE salesFunc

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.

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.

Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?

A. The OLD correlation-name and the OLD TABLE identifier can be used if the trigger event is an INSERT operation.

B. The scope of each correlation-name and identifierused is the entire trigger definition.

C. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE trigger.

D. A NEW correlation-name can be specified more than once for a trigger.