000-545 무료 덤프문제 온라인 액세스

Which two types of stored procedures can be developed in IBM Data Studio? (Choose two.)

• A.PHP
• B.SQL
• C.Ruby
• D.PL/SQL
• E.Perl

Given the following statements in an SQL procedure:

Which of the following assignment statements is valid?

• A.SET c1 = CURSOR FOR VALUES (1, 2, 3);
• B.SET VALUES (1, 2, 3) for CURSOR c1;
• C.c1 = CURSOR VALUES (1, 2, 3);
• D.SET c1 = VALUES (1, 2, 3);

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 does not always return the same results for a given argument value?

• A.NOT FENCED
• B.STATIC DISPATCH
• C.NO EXTERNAL ACTION
• D.NOT DETERMINISTIC

Which statement will change the value of a special register?

• A.SET CURRENT SCHEMA = 'DB2ADMIN'
• B.SET CURRENT TIME = ?2:30:00?SET CURRENT TIME = ?2:30:00
• C.UPDATE SPECIAL REGISTER SCHEMA = 'DB2ADMIN'
• D.UPDATE SPECIAL REGISTER TIME = ?2:30:00?UPDATE SPECIAL REGISTER TIME = ?2:30:00

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