DELETE ALL FROM tab01 FOR CURRENT OF csr01
DELETE FROM tab01 FOR CURRENT csr01 WITH RS
DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
第1题:
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If 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
第2题:
第3题:
A.mysql_fetch_object和mysql_fetch_array一样,没什么区别
B.mysql_fetch_object返回值是个对象,所以在速度上比mysql_fetch_array要慢
C.mysql_fetch_object返回值是个数组,所以在速度上和mysql_fetch_array及mysql_fetch_row差不多
D.mysql_fetch_object返回值是个对象,在速度上和mysql_fetch_array及mysql_fetch_row差不多
第4题:
取得查询语句的结果集中的记录函数有()
第5题:
设有Teachers表,该表的定义如下: CREATE TABLE Teachers( Tno CHAR(8) PRIMARY KEY, Tname VARCHAR(10) NOT NULL, Age TINYINT CHECK(Age BETWEEN 25 AND 65) ) 下列插入语句中,不能正确执行的是()。
AINSERT INTO Teachers VALUES(’T100’,’张宏’,NULL)
BINSERT INTO Teachers(Tno,Tname,Age) VALUES(’T100’,’张宏’,30)
CINSERT INTO Teachers(Tno,Tname) VALUES(’T100’,’张宏’)
DINSERT INTO Teachers VALUES(’T100’,’张宏’)
第6题:
A.每当对游标执行一次FETCH语句,系统都会自动对@@FETCH_STATUS赋一次值
B.用户可以对@@FETCH_STATUS变量进行赋值
C.用户可以在游标中声明@@FETCH_STATUS变量
D.每个游标都有一个专属于自己的@@FETCH_STATUS变量
第7题:
第8题:
A.The CONNECT statement
B.The first FETCH of a cursor
C.The BEGIN TRANSACTION statement
D.The first executable SQL statement
第9题:
关于HQL的连接查询,说法错误的是()。
第10题:
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?()