单选题Which of the following will DELETE all of the rows from table T03?（）A DELETE * FROM TABLE T03B DELETE ALL FROM T03C DELETE * FROM T03D DELETE FROM T03

题目
单选题
Which of the following will DELETE all of the rows from table T03?（）
A

DELETE * FROM TABLE T03

B

DELETE ALL FROM T03

C

DELETE * FROM T03

D

DELETE FROM T03

相似考题

1.删除用户账号命令是( )A.DROP USERB.DROP TABLE USERC.DELETE USERD.DELETE FROM USER

2.根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用?()A delete from studentB delete all from studentC delete * from studentD drop table student

3.delete from tablea & truncate table tablea的区别

4.找出正确的叙述()A DROP TABLE表示删除表的定义B DELETE FROM TABLE表示删除表的定义C DROP TABLE 等于DELETE FROM TABLED DROP TABLE属于数据操纵语言

更多“单选题Which of the following will DELETE all of the rows from table T03?（）A DELETE * FROM TABLE T03B DELETE ALL FROM T03C DELETE * FROM T03D DELETE FROM T03”相关问题

  • 第1题：

    设有学生表：STUD(学号，姓名，性别，年龄，专业)，将学号为“20030019”的学生从该表中删除掉的语句是______。

    A．DELETE STUD WHERE学号="20030019"

    B．DELETE FROM STUD WHERE学号="20030019"

    C．DELETE TABLE STUD WHERE学号="20030019"

    D．DELETE FROM WHERE 学号="20030019"


    正确答案：B

  • 第2题：

    Which of the following will DELETE all of the rows from table T03?()

    A.DELETE * FROM TABLE T03

    B.DELETE ALL FROM T03

    C.DELETE * FROM T03

    D.DELETE FROM T03


    参考答案：D

  • 第3题：

    请问oracle的整表删除操作（）是正确的。

    • A、truncate table tablename
    • B、delete from tablename
    • C、delete*from tablename
    • D、以上都不对

    正确答案:A,B

  • 第4题：

    下列哪一个命令为删除sample数据库的tb_name表（）。

    • A、delete from tb_name
    • B、delete from samplE.tb_name
    • C、drop table samplE.DBO.tb_name
    • D、drop table samplE.tb_name

    正确答案:C

  • 第5题：

    删除emp表的全部数据，但不提交，以下正确的语句是（）

    • A、DELETE * FROM. EMP
    • B、DELETE FROM EMP
    • C、TRUNCATE TABLE EMP
    • D、DELETE TABLE EMP"

    正确答案:B

  • 第6题：

    若要删除book表中所有数据，以下语句错误的是（）

    • A、truncate table book 
    • B、delete * from book
    • C、drop table book 
    • D、delete from book

    正确答案:B,C

  • 第7题：

    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

    正确答案:D

  • 第8题：

    Which of the following will DELETE all of the rows from table T03?（）

    • A、DELETE * FROM TABLE T03
    • B、DELETE ALL FROM T03
    • C、DELETE * FROM T03
    • D、DELETE FROM T03

    正确答案:D

  • 第9题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第10题：

    delete from system.table1与truncate table system.table1区别是什么？


    正确答案: Delete语句删除记录并不能释放Oracle中占用的数据块表空间，它只把删除的数据块标记为unused，可恢复。
    Truncate语句删除表中的全部记录，释放占用的数据块表空间，不能恢复。

  • 第11题：

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）
    A

    It fails with a Resource Busy error.

    B

    It deletes the rows successfully because the table is locked in SHARE mode.

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()

    A.REVOKE DROP ON t1 FROM PUBLIC

    B.REVOKE UPDATE ON t1 FROM PUBLIC

    C.REVOKE DELETE ON t1 FROM PUBLIC

    D.REVOKE CONTROL ON t1 FROM PUBLIC


    参考答案：C

  • 第14题：

    若要删除book表中所有数据,以下语句错误的是哪两项?()

    A.delete all from book

    B.delete from book

    C.truncate table book

    D.drop table book


    参考答案：BC

  • 第15题：

    ORACLE数据库中如何删除表table中的所有记录，并回收所有空间（）

    • A、delete * from table
    • B、delete from table
    • C、truncate table
    • D、clear table

    正确答案:C

  • 第16题：

    在Access中，删除"订单"表中所有记录，应运行的SQL命令是（）

    • A、delete*from"订单"
    • B、delete*from订单
    • C、delete*from"订单ID"
    • D、delete*from订单ID

    正确答案:B

  • 第17题：

    设有一张教师表js，含有一个字符型字段xb（表示教师的性别）。下列命令中语法正确的是（）

    • A、DELETE FROM js WHERE xb="男"
    • B、DELETE TABLE js WHERE xb="男"
    • C、DELETE FROM js FOR xb="男"
    • D、DELETE TABLE js FOR xb="男"

    正确答案:A

  • 第18题：

    删除表Teacher中编号为070041的记录，应为（）

    • A、DELETE FROM Teacher WHERE编号="070041"
    • B、DELETE FROM Teacher 编号="070041"
    • C、DELETE编号="070041"FROMTeacher
    • D、DELETE FROM Teacher WHERE编号IS"070041"

    正确答案:A

  • 第19题：

    Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）

    • A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
    • B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
    • C、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
    • D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

    正确答案:D

  • 第20题：

    Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

    • A、REVOKE DROP ON t1 FROM PUBLIC
    • B、REVOKE UPDATE ON t1 FROM PUBLIC
    • C、REVOKE DELETE ON t1 FROM PUBLIC
    • D、REVOKE CONTROL ON t1 FROM PUBLIC

    正确答案:C

  • 第21题：

    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）

    • A、It fails with a "Resource Busy" error.
    • B、It deletes the rows successfully because the table is locked in SHARE mode.
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第22题：

    单选题
    Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）
    A

    REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

    B

    REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

    C

    REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

    D

    REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following will DELETE all of the rows from table T03?（）
    A

    DELETE * FROM TABLE T03

    B

    DELETE ALL FROM T03

    C

    DELETE * FROM T03

    D

    DELETE FROM T03


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）
    A

    REVOKE DROP ON t1 FROM PUBLIC

    B

    REVOKE UPDATE ON t1 FROM PUBLIC

    C

    REVOKE DELETE ON t1 FROM PUBLIC

    D

    REVOKE CONTROL ON t1 FROM PUBLIC


    正确答案： C
    解析： 暂无解析

相关内容