网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 csr01B DELETE FROM tab01 FOR CURRENT csr01 WITH RSC DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR” 相关考题
考题
关于mysql_fetch_object说法中,正确的是:()。
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差不多
考题
Which of the following will begin a new unit of work?()
A.The CONNECT statementB.The first FETCH of a cursorC.The BEGIN TRANSACTION statementD.The first executable SQL statement
考题
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 csr01B.DELETE FROM tab01 FOR CURRENT csr01 WITH RSC.DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD.DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
考题
下列关于SQL Server 2008游标中@@FETCH_STATUS的说法,正确的是( )。
A.每当对游标执行一次FETCH语句，系统都会自动对@@FETCH_STATUS赋一次值B.用户可以对@@FETCH_STATUS变量进行赋值C.用户可以在游标中声明@@FETCH_STATUS变量D.每个游标都有一个专属于自己的@@FETCH_STATUS变量
考题
设有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’，’张宏’）
考题
关于HQL的连接查询，说法错误的是（）。A、inner join 或 join用于内连接B、inner join fetch或 join fetch用于迫切内连接C、left outer join fetch 或 left join fetch用于迫切左外连接D、right outer join fetch 或 right join fetch用于迫切右外连接
考题
取得查询语句的结果集中的记录函数有（）A、mysql_fetch_rowB、mysql_fetch_assocC、mysql_num_rowsD、mysql_fetch_arrayE、mysql_fetch_object
考题
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 csr01B、DELETE FROM tab01 FOR CURRENT csr01 WITH RSC、DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD、DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
考题
Which of the following will begin a new unit of work?（）A、The CONNECT statementB、The first FETCH of a cursorC、The BEGIN TRANSACTION statementD、The first executable SQL statement
考题
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A、 The statement will be executed successfully， and a new time zone will be set for the database.B、 The statement will be executed successfully， but a new time zone will not be set for the database.C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
考题
You created the ORDERS table in your database by using the following code： SQL CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL COMMIT； Next， you issued the following statement to change the time zone for the database： SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（） A、 The statement will fail.B、 The statement will be executed successfully， and the new time zone will be set for the database.C、 The statement will be executed successfully， but the new time zone will be set for the current session.D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
考题
A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）A、Acquire locks on table queried B、Generate redo for statement C、Fetch data from disk into memory D、Write changes to disk
考题
多选题取得查询语句的结果集中的记录函数有（）Amysql_fetch_rowBmysql_fetch_assocCmysql_num_rowsDmysql_fetch_arrayEmysql_fetch_object
考题
单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A
The statement will be executed successfully， and a new time zone will be set for the database.B
The statement will be executed successfully， but a new time zone will not be set for the database.C
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D
The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
考题
单选题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 csr01B
DELETE FROM tab01 FOR CURRENT csr01 WITH RSC
DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD
DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
考题
单选题设有Teachers表，该表的定义如下： CREATE TABLE Teachers（ Tno CHAR（8） PRIMARY KEY， Tname VARCHAR（10） NOT NULL， Age TINYINT CHECK（Age BETWEEN 25 AND 65） ） 下列插入语句中，不能正确执行的是（）。A
INSERT INTO Teachers VALUES（’T100’，’张宏’，NULL）B
INSERT INTO Teachers（Tno，Tname，Age） VALUES（’T100’，’张宏’，30）C
INSERT INTO Teachers（Tno，Tname） VALUES（’T100’，’张宏’）D
INSERT INTO Teachers VALUES（’T100’，’张宏’）
考题
单选题关于HQL的连接查询，说法错误的是（）。A
inner join 或 join用于内连接B
inner join fetch或 join fetch用于迫切内连接C
left outer join fetch 或 left join fetch用于迫切左外连接D
right outer join fetch 或 right join fetch用于迫切右外连接
考题
单选题Which of the following will begin a new unit of work?（）A
The CONNECT statementB
The first FETCH of a cursorC
The BEGIN TRANSACTION statementD
The first executable SQL statement
考题
单选题You created the ORDERS table in your database by using the following code： SQL CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL COMMIT； Next， you issued the following statement to change the time zone for the database： SQL ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（）A
The statement will fail.B
The statement will be executed successfully， and the new time zone will be set for the database.C
The statement will be executed successfully， but the new time zone will be set for the current session.D
The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
考题
单选题关于mysql_fetch_object说法中，正确的是：（）。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差不多
考题
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it
考题
单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A
It contains only the plan for the SQL statement executed by the user.B
It contains the SQL text executed by the user and the bind variables used with it.C
It contains the plan and statistics associated with the SQL statement executed by the user.D
It contains the plan for the SQL statement executed by the user and the bind variables used with it.
热门标签
最新试卷
