IBM Exam Questions

Which of the following DELETE statements will cause this row to be deleted?

The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO
123 Brown John T100
213 Bailey James T100

312 Carter Arlene T210
465 Chas Devon T305
546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row to be deleted?

A.
DELETE ALL FROM tab01 FOR CURRENT OF csr01

B.
DELETE FROM tab01 FOR CURRENT csr01 WITH RS

C.
DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS

D.
DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR