IBM(000-730)

单选题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题：

根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用?()

A delete from student

B delete all from student

C delete * from student

D drop table student


参考答案A

第2题：

设有学生表：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

第3题：

删除用户账号命令是( )

A.DROP USER

B.DROP TABLE USER

C.DELETE USER

D.DELETE FROM USER


正确答案：A 

第4题：

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

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

正确答案:A,B

第5题：

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

第6题：

delete from tablea & truncate table tablea的区别


正确答案：

 

truncate 语句执行速度快,占资源少,并且只记录页删除的日志；
delete 对每条记录的删除均需要记录日志

第7题：

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

第8题：

找出正确的叙述()

A DROP TABLE表示删除表的定义

B DELETE FROM TABLE表示删除表的定义

C DROP TABLE 等于DELETE FROM TABLE

D DROP TABLE属于数据操纵语言


参考答案A

第9题：

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

A.delete all from book

B.delete from book

C.truncate table book

D.drop table book


参考答案：BC

第10题：

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

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

正确答案:C

更多相关问题
相关内容