题目内容

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=’ 张三’

student表设计如下,查询所有‘男‘同学的信息正确SQL语句是()。

A. select sname from student where sex=’ 男’
B. select * from student where sex=’ 男’
C. select all from student where sex=’ 男’
D. select * from student where sex=男

答案查题题库