若用如下的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;
微信支付 
支付宝支付