题目内容

course表设计如下:通过SQL语句的delete语句来删除记录,将‘数据结构‘的课程信息全删除。 正确的SQL语句是()

A. delete all from course where cname=’ 数据结构’
B. delete from course where cname=数据结构
C. delete from course where cname=’ 数据结构’
D. delete course where cname=’ 数据结构’

查看答案
更多问题

student表设计如下,通过SQL语句的delete语句来删除记录, 学号为‘20140199‘成绩信息删除。 正确的SQL语句是()

A. delete all from course where cname=’ 20140199’
B. delete from course where sno=’ 20140199’
C. delete all from course where sno=’ 20140199’
D. delete all from course where sno=20140199

student表设计如下,将学生信息表的数据全部删除的正确SQL语句是()

A. delete all from student
B. delete from student
C. delete from student where cno=all
D. tuncate from student l

删除学生信息student表结构的的正确SQL语句是()

A. drop table student
B. alter table student
C. delete student
D. delete table student

student表设计如下,查询‘张三‘同学的信息的正确SQL语句是()

A. select sname from student where cname=’ 张三’
B. select * from student where cname=’ 张三’
C. select * from student where cname=张三
D. select all from student where cname=’ 张三’

答案查题题库