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=男