下列语句用来删除表对象或表数据，其中不正确的语句是（）。 A: TRUNCATE TABLE book B: DELETE * FROM book C: DROP TABLE book D: DELETE FROM book

2022-06-15

下列语句用来删除表对象或表数据，其中不正确的语句是（）。
A: TRUNCATE TABLE book
B: DELETE * FROM book
C: DROP TABLE book
D: DELETE FROM book

答案：

B

0
若要删除book表中所有数据，以下语句正确的是( )。 A: TRUNCATE TABLE book B: TRUNCATE book C: TRUNCATE FROM book D: TRUNCATE * TABLE book
1
下列语句用来删除数据表中指定记录，正确的语句是（）。‍ A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
2
若要删除book表中所有数据，以下语句错误的是（） A: Atruncate table book B: Bdelete * from book C: Cdrop table book D: Ddelete from book
3
SQL用来删除表的语句是()。 A: DELETE B: DROP TABLE C: TRUNCATE TABLE D: DELETE TABLE
4
删除test表中所有数据的语句为 A: drop table test; B: delete table test; C: delete from test; D: truncate test;