删除student表所有的记录，下列语句正确的是
A: DELETE FROM TABLE student;
B: DELETE TABLE student;
C: TRUNCATE TABLE student;
D: TRUNCATE FROM TABLE student;
A: DELETE FROM TABLE student;
B: DELETE TABLE student;
C: TRUNCATE TABLE student;
D: TRUNCATE FROM TABLE student;
C
举一反三
- 使角色 R1 在原来的基础上增加 Student 表的 DELETE 权限的语句是 A: GRANT DELETE ON TABLE Student FROM R1 B: GRANT DELETE ON TABLE Student TO R1 C: REVOKE DELETE ON TABLE Student FROM R1 D: REVOKE DELETE ON TABLE Student TO R1
- 删除学生信息表student的所有数据，正确的语句为（ ）。 A: delete from student B: drop all from student C: delete all * from student D: drop table student
- 删除数据表Student中的数据，应该使用（）。 A: Drop Table Student B: Delete from Student C: Delete table D: Drop Student
- 以下语句能正确删除数据表“Student”的是（ ）。 A: DELETE TABLE Student B: DROP Student C: DROP TABLE Student D: DELETE Student
- 删除当前数据库中的表Student的语句应当是（ ）。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
内容
- 0
删除当前数据库中名为Student的表，以下SQL语句正确的是______。 A: DROP TABLE Student B: DELETE TABLE Student C: REMOVE TABLE Student D: CLEAR TABLE Student
- 1
若要删除数据库中已经存在的表Student,可( )。 A: DELETE TABLE Student B: DELETE Student C: DROP Student D: DROP TABLE Student
- 2
学生表student中，将年龄小于30岁的记录删除，下面的语句正确的是（ ）。 A: DELETE FROM student FOR age<;30 B: DELETE FROM student WHERE age<;30 C: DELETE TABLE student WHERE age<;30 D: DELETE FROM student HAVING age<;30
- 3
如果要删除数据库中已经存在的表Student，可以使用（）。 A: DELETE TABLE Student B: DELETE Student C: DROP TABLE Student D: DROP Student
- 4
删除数据表student的命令是________。 A: drop table student; B: drop student; C: delete table student; D: drop student;