Given the following SQL:
Which of the following statements is true?
A. The cursor declaration requires WITH RETURN TO CALLER clause in order to return a result set.
B. The cursor declaration requires WITH RETURN clause in order to return a result set.
C. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
D. The cursor declaration requires WITH RETURN TO CLIENT clause in order to return a result set.
正解:D
質問 2:
What is a reason to use SQL procedures in DB2?
A. to eliminate the need for testing
B. to move business logic rules into the database
C. to reduce code sharing
D. to use different programming languages
正解:B
質問 3:
Which statement is TRUE about associative arrays?
A. Associative array cannot be a type of a table column.
B. The index data type for an associated array must be an integer.
C. Associative array values can be stored in table columns.
D. The index values for an associative array must be a continuous set of integer values.
正解:A
質問 4:
What values are generated each time an SQL statement is executed?
A. SQLSTATE and EXCEPTION
B. SQLERRN and SQLMSG
C. EXCEPTION and SQLCODE
D. SQLSTATE and SQLCODE
正解:D
質問 5:
If the following SQL statements were executed in the order shown: What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTER procedure?
A. 123, 123
B. 100 , 1
C. 100, 0
D. 100, 100
正解:B
質問 6:
Click the Exhibit button.
The table and triggers in the exhibit have been created successfully, when the statements shown below are executed.
INSERT INTO emp_hours VALUES('KAY', '9:00', '17:00');
INSERT INTO emp_hours (emp_name, starting) VALUES('BILL', '9:00');
What is the result?
A. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM
B. Table EMP_HOURS will contain this row: BILL 9:00:00 AM
C. Table EMP_HOURS will contain this row: BILL 9:00:00 AM 17:00:00 PM
D. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM 10:00:00 AM
正解:D
Jitsukawa -
身に着けた知識は、本書に付属するアプリでしっかりと反復演習を行うことで、C2090-545試験対策ができます。一冊で十分カバー出来ます。