DB2 10.1 Fundamentals: C2090-610

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 ONLY

B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY

C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

A. Define a view on one or more tables or views.

B. Revalidate all invalid objects that are referenced on a view's fullselect.

C. Ensure that any inserted or updated rows conform to the definition of the view.

D. Define a view that only consists of columns that have check constraints defined.

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Read stability (RS)

B. Cursor stability (CS)

C. Repeatable read (RR)

D. Uncommitted read (UR)