单项选择题
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
相关考题
-
单项选择题
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）
A.REVOKE SELECT FROM user2 ON TABLE org.tab1
B.REVOKE SELECT ON TABLE org.tab1 FROM user2
C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2 -
单项选择题
On which of the following database objects may the SELECT privilege be controlled?（）
A.Sequence
B.Schema
C.Group
D.View -
单项选择题
A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?（）
A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system
