Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
A. View
B. Identity Column
C. Table
D. Sequence
正解:D
質問 2:
If the following result set is desired:
Which SQL statement must be executed?
A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS
C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY
D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY
正解:C
質問 3:
Which DB2 object can be used to improve the execution performance of qualified SELECT statements?
A. Sequence Object
B. Materialized Query Table
C. Trigger
D. SQL Procedure
正解:B
質問 4:
What is the minimum product required for DB2 connectivity across all platforms?
A. DB2 Development Unlimited Edition
B. DB2 Development Edition
C. DB2 Personal Edition
D. DB2 Connect Personal Edition
正解:D
質問 5:
Which statement about roll back operations is correct?
A. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are released.
B. When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.
C. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.
D. When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.
正解:D
質問 6:
Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?
A. SALES can be the name of a schema.
B. SALES can be the name of an existing alias.
C. SALES can be the name of a package.
D. SALES can be the name of a declared global temporary table.
正解:B
質問 7:
If a table named MY_TAB contains 100 rows and the following statement is executed:
How many rows will be updated?
A. 0
B. 99
C. 1
D. 10
正解:D
Natsuko -
必要十分な知識をギュッとまとめた完成度の高いテキストで、メリハリよくC2090-610を学習することができます。