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题:
第2题:
设有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’,’张宏’)
第3题:
取得查询语句的结果集中的记录函数有()
第4题:
Which of the following will begin a new unit of work?()
第5题:
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?()
第6题:
简述mysql_fetch_row()和mysql_fetch_array之间有什么区别?
第7题:
The statement will be executed successfully, and a new time zone will be set for the database.
The statement will be executed successfully, but a new time zone will not be set for the database.
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
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.
第8题:
INSERT INTO Teachers VALUES(’T100’,’张宏’,NULL)
INSERT INTO Teachers(Tno,Tname,Age) VALUES(’T100’,’张宏’,30)
INSERT INTO Teachers(Tno,Tname) VALUES(’T100’,’张宏’)
INSERT INTO Teachers VALUES(’T100’,’张宏’)
第9题:
mysql_fetch_row
mysql_rowid
mysql_num_rows
mysql_fetch_array
第10题:
第11题:
mysql_fetch_object和mysql_fetch_array一样,没什么区别
mysql_fetch_object返回值是个对象,所以在速度上比mysql_fetch_array要慢
mysql_fetch_object返回值是个数组,所以在速度上和mysql_fetch_array及mysql_fetch_row差不多
mysql_fetch_object返回值是个对象,在速度上和mysql_fetch_array及mysql_fetch_row差不多
第12题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it
第13题:
第14题:
关于HQL的连接查询,说法错误的是()。
第15题:
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?()
第16题:
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?()
第17题:
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?()
第18题:
mysql_fetch_row
mysql_fetch_assoc
mysql_num_rows
mysql_fetch_array
mysql_fetch_object
第19题:
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
第20题:
inner join 或 join用于内连接
inner join fetch或 join fetch用于迫切内连接
left outer join fetch 或 left join fetch用于迫切左外连接
right outer join fetch 或 right join fetch用于迫切右外连接
第21题:
The CONNECT statement
The first FETCH of a cursor
The BEGIN TRANSACTION statement
The first executable SQL statement
第22题:
The statement will fail.
The statement will be executed successfully, and the new time zone will be set for the database.
The statement will be executed successfully, but the new time zone will be set for the current session.
The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
第23题:
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
第24题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it.