IBM C2090-545 問題集

質問 1：
Given the two SQL procedures shown below:

What is the expected output if procedure S1 is invoked with the value 1 provided for parameter V1?
A. 2
B. NULL
C. 7
D. 5
正解：C

質問 2：
Given the SQL statement shown below: Which privilege allows a user to execute the CREATE TRIGGER statement shown?

A. SYSMAINT authority
B. SYSCTRL authority
C. SELECT and UPDATE privilege on the EMPLOYEE table
D. SELECT and ALTER privilege on the EMPLOYEE table
正解：C

質問 3：
Click the Exhibit button.

The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?
A. 2
B. 3
C. 4
D. 1
正解：B

質問 4：
Given the function:

What is the output of the statement: VALUES LENGTH(fcn1(' one good day '))?
A. 12
B. ' one good day '
C. 14
D. 'one good day'
正解：A

質問 5：
Which two statements are true with regards to nesting SQL procedures? (Choose two.)
A. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java).
B. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL 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 can invoke the same SQL procedure more than once.
E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause.
正解：B,D

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

質問 7：
Click the Exhibit button.

A trigger was created as shown in the exhibit.
The UPDATE statement shown below is executed. UPDATE dept SET sales_id = '300' WHERE sales_id = '200'
How many row(s) are updated in the EMPLOYEE table?
A. 0
B. 2
C. 3
D. 1
正解：D

質問 8：
Which statement will successfully create an SQL procedure that returns the name of the current month?
A. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
SET month = MONTHNAME(SELECT (CURRENT_DATE))
END
B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SELECT (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
VALUES (CURRENT_DATE) INTO today;
SET month = MONTHNAME(today);
END
D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20))
BEGIN
DECLARE today DATE;
SET (today = CURRENT_DATE);
SET month = MONTHNAME(today);
END
正解：C

質問 9：
Given the following statements in an SQL procedure:

Which of the following assignment statements is valid?
A. c1 = CURSOR VALUES (1, 2, 3);
B. SET c1 = VALUES (1, 2, 3);
C. SET VALUES (1, 2, 3) for CURSOR c1;
D. SET c1 = CURSOR FOR VALUES (1, 2, 3);
正解：D