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
質問 2:
Which statement is true about the NUMBER data type?
A. Declaring a column as NUMBER(6,8) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.
B. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.
C. Declaring a column as NUMBER(10,-2) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.
D. In DB2, the NUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.
正解:D
質問 3:
Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?
A. ... BEGIN IF SQLCODE < 0 THEN RETURN -6786 END;
B. ...
IF SQLCODE < 0 THEN
RETURN -6786;
END IF;
...
C. ...
BEGIN
EXCEPTION < 0
ELSE;
NULL;
END;
...
D. ...
IF
EXCEPTION < 0
ELSE THEN;
NULL;
ENDIF;
...
正解:B
質問 4:
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. SQL0440N No authorized routine named "E_DEGREE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884
B. 1
BACHELOR 1 record(s) selected.
C. 1
MASTER 1 record(s) selected.
D. 1
UNKNOWN 1 record(s) selected.
正解:D
質問 5:
Which two statements are true with regards to nesting SQL procedures? (Choose two.)
A. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.
B. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA 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 cannot invoke procedures built in other languages (e.g., C, Java).
正解:A,D
質問 6:
Given the function:
What is the output of the statement: VALUES LENGTH(fcn1(' one good day '))?
A. 14
B. 'one good day'
C. ' one good day '
D. 12
正解:D
Jitsukawa -
身に着けた知識は、本書に付属するアプリでしっかりと反復演習を行うことで、C2090-545試験対策ができます。一冊で十分カバー出来ます。