최신IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545무료샘플문제

A. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.

B. 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.

C. 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.

D. In DB2, the NUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.

A. ...
IF
EXCEPTION < 0
ELSE THEN;
NULL;
ENDIF;
...

B. ...
IF SQLCODE < 0 THEN
RETURN -6786;
END IF;
...

C. ... BEGIN IF SQLCODE < 0 THEN RETURN -6786 END;

D. ...
BEGIN
EXCEPTION < 0
ELSE;
NULL;
END;
...

A. The row will be found with the same ROW CHANGE TOKEN. Transaction 2 will now insert its values replacing those of transaction 1.

B. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 will complete with an insert of a new row.

C. The row will be found with a different ROW CHANGE TOKEN and Transaction 2 will overwrite the values set in transaction 1.

D. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 has to retry in order to retrieve the current data.

A. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

B. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)

C. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)

D. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

A. 4

B. 2

C. 1

D. 3

A. SQL procedures cannot be called from triggers.

B. SQL procedures support recursion.

C. SQL procedures reside outside of the database for easy portability.

D. SQL procedures may return multiple result sets to the caller or to a client application.

E. SQL procedures support the PRINT statement.

A. 2323

B. 1010

C. 66

D. 0

A. The index data type for an associated array must be an integer.

B. Associative array values can be stored in table columns.

C. The index values for an associative array must be a continuous set of integer values.

D. Associative array cannot be a type of a table column.

A. 100, 100

B. 123, 123

C. 100 , 1

D. 100, 0