scores表设计如下，通过SQL语句的update语句来修改记录,将学号和课程号分别为‘20140199‘、’0803‘的成绩改为78分。 正确的SQL语句是（）
A. update scores set score=78 where cname=’ 0803’ and sno=’ 20140199’
B. update scores set score=78 where cname=’ 0803’ or sno=’ 20140199’
C. update scores set score=’78’ where cno=’ 0803’ or sno=’ 20140199’
D. update scores set score=78 where cname=’ 0803’ and sno=’ 20140199’
查看答案
student表设计如下：通过SQL语句的delete语句来删除记录,将姓名为‘张三‘的学生信息删除。 正确的SQL语句是（ ）
A. delete from student where sname=张三
B. delete student where cname=’ 张三’
C. delete student where sname=’ 张三’
D. delete from student where sname=’ 张三’
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
微信支付 
支付宝支付