若用如下的SQL语句创建一个表SC:CREATE TABLE SC (Sno CHAR(6) NOT NULL,Cno CHAR(3) NOT NULL,SCORE INTEGER, NOTE CHAR(20))；向SC表中插入如下行时，以下哪行可以被插入？
A. （‘201009’，‘101’，NULL，必修）
B. （‘200823’，‘101’，NULL，NULL）
C. （NULL，‘103’，80，‘选修’）
D. （‘201132’，NULL，86，‘’）
查看答案
有学生表Student(Sno char(8), Sname char(10), Ssex char(2),Sage integer, Dept char(2), Sclass char(6))。若要“检索名字为张某某的所有同学姓名”，下列SQL语句正确的是?
A. Select Sname From Student Where Sname Like ‘张%’;
B. Select Sname From Student Where Sname Like ‘张_’;
C. Select Sname From Student Where Sname Not Like ‘张_ _’;
D. Select Sname From Student Where Sname Like ‘张_ _’;
有关系表SC ( Sno , Cno, Score)，求既学过“001”号课又学过 “002”号课的所有学生的学号，下列SQL语句正确的是?
A. Select Sno From SC Where Cno = ‘001’ AND Cno=‘002’;
B. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ ;
C. Select S2.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno or S1.Cno=‘001’ and S2.Cno=‘002’ ;
D. Select S1.Sno From SC S1 Where S1. Cno = ‘001’ AND S1.Cno=‘002’;
有关系表SC(Sno , Cno, Score)，求“001”号课成绩比“002”号课成绩高的所有学生的学号。下列SQL语句正确的是?
A. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S2.Score > S1.Score;
B. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002 ;
C. Select S1.Sno From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S1.Score > S2.Score;
D. Select * From SC S1, SC S2 Where S1.Sno = S2.Sno and S1.Cno=‘001’ and S2.Cno=‘002’ and S1.Score > S2.Score;
已知如下关系：学生Student(Sno, Sname)，课程Course(Cno, Cname, Tno)，选课SC(Sno, Cno, Score)，教师T(Tno, Tname)。其中Sno为学号，Sname为学生命名，Cno为课号，Cname为课程名，Tno为教师编号，Score为成绩，Tname为教师名。阅读SQL语句:SELECT Sname FROM Student, SC, Course WHERE Student.Sno=SC.Sno ANDCourse.Cno=SC.Cno AND Tno= ‘T01’ AND Score<60；关于其查询结果，下列说法正确的是？
A. 课程不及格的所有学生的姓名
B. 学习非T01号教师讲授课程不及格的所有学生的姓名
C. 学习T01号教师讲授课程及格的所有学生的姓名
D. 学习T01号教师讲授课程不及格的所有学生的姓名
微信支付 
支付宝支付