IBM A2090-545 問題集

質問 1：
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

質問 2：
Which of the following can be used to assign multiple values to a row data type variable?
A. A SELECT * statement, a VALUES * statement, or a FETCH * statement.
B. A DIRECT ASSIGNMENT statement.
C. A VARIABLE VALUES statement.
D. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.
正解：D

質問 3：
Which two statements are true when working with triggers? (Choose two.)
A. Triggers can be used on Created Temporary Tables.
B. Triggers can be used on Materialized Query Tables.
C. Triggers can be altered.
D. Triggers can be used to enforce data integrity rules.
E. Triggers can be used with both tables and views.
正解：D,E

質問 4：
Which statement is true about the NUMBER data type?
A. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.
B. In DB2, the NUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.
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. 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.
正解：B

質問 5：
Given the procedure show below: What will be the value of P2?

A. 51
B. 50
C. 102
D. 100
正解：D

質問 6：
Click the Exhibit button.

Which statement is true about the CASE statement shown in the exhibit?
A. An employee with a rating of 2 receives a 3% salary increase.
B. An employee with a rating of 1 receives a 10% salary increase.
C. An employee with a rating of 3 receives no salary increase.
D. All employees will receive at least a 5% salary increase.
正解：B

質問 7：
In the code segment shown below: Which statement accurately describes the result?

A. For activities whose description has changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
B. The statement will fail since MERGE is not a supported operator.
C. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
D. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.
正解：C

質問 8：
Given the following SQL:

Which statement is incorrect?
A. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
B. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
C. The cursor declaration requires the WITH RETURN clause in order to return a result set.
D. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
正解：D

質問 9：
How is the FOR statement distinct from other conditional statements?
A. FOR statements are evaluated at the completion of each iteration of the loop.
B. FOR statements are used to iterate over rows in a defined read-only result set.
C. FOR statements have a terminating condition clause.
D. FOR statements are evaluated before each iteration of the loop.
正解：B