若用如下的SQL语句创建一个表SC:
CREATE TABLE SC (S# CHAR(6) NOT NULL,C# CHAR(3) NOT NULL,SCORE INTEGER, NOTE CHAR(20));
向SC表中插入如下行时,____B_____行可以被插入。
得分/总分
A.
(‘201132’,NULL,86,‘’)
B.
(‘200823’,‘101’,NULL,NULL)
1.00/1.00
C.
(‘201009’,‘101’,NULL,必修)
D.
(NULL,‘103’,80,‘选修’)
2
单选(1分)
有关系表SC ( S# , C#, Score),求既学过“001”号课又学过 “002”号课的所有学生的学号,下列SQL语句正确的是____B_____。
得分/总分
A.
Select S1.S# From SC S1 Where S1. C# = ‘001’ AND S1.C#=‘002’;
B.
Select S1.S# From SC S1, SC S2 Where S1.S# = S2.S# and S1.C#=‘001’ and S2.C#=‘002 ;
1.00/1.00
C.
Select S2.S# From SC S1, SC S2 Where S1.S# = S2.S# or S1.C#=‘001’ and S2.C#=‘002 ;
D.
Select S# From SC Where C# = ‘001’ AND C#=‘002’;
3
单选(1分)<