制定并发布《会计档案管理办法》的单位是（)。 A、审计署、财政部 B、财政部、国家保密局

A．只有I

B．只有II

C．只有III

D．都正确

查询“选修了课程号C#='C2'的学生的学生号”，正确的表示是()。

Ⅰ. ∏S#(OC#='C2'(SC) ) Ⅱ. OC#='C2'(∏S#(S))

Ⅲ. SELECT S#FROM SC WHERE C#='C2'

A) 仅Ⅰ和Ⅱ

B) 仅Ⅱ和Ⅲ

C) 仅Ⅰ和Ⅲ

D) 都正确

A．仅I和II

B．仅II和III

C．仅I和III

D．都正确

（41）若要查询“选修了课程号为C2的学生的学生号”，正确的表达是（）.

Ⅰ、pS#(sC#=′C2′(SC)) Ⅱ、sC#=′C2′(pS# (S))

Ⅲ、SELECT S# FROM SC WHERE C#=′C2′

A）仅Ⅰ和Ⅱ

B）仅Ⅱ和Ⅲ

C）仅Ⅰ和Ⅲ

D）都正确

查询选修了课程号为“C2”的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的？

A．SELECT S.S#，SNAME FROM S WHERE S.S# (SELECT SC. S# FROM SC WHERE C#='C2')

B．SELECT S.S#，SNAME FROMS，SC WHERE S.S#=SC.S# AND C#='C2'

C．SELECT S.S#，SNAME FROM S,SC WHERE S.S=SC．S# AND C#='C2'ORDER BY S.S#．

D．SELECTS.S#，SNAME FROM S WHERE S.S# IN(SELECT SC. S# FROM SC WHERE C#='C2')

A．SELECT S# FROM SC WHERE C#=C2 AND GRADE>=（SELECT GRADE FROM SC WHERE C#=C2）

B．SELECT S# FROM SC WHERE C#=C2 AND GRADE IN（SELECT GRADE FROM SC WHERE C#=C2）

C．SELECT S# FROM SC WHERE C#=C2 AND GRADE NOT IN （SELECT GRADE GORM SC WHERE C#=C2）

D．SELECT S# FROM SC WHERE C#=C2 AND GRADE>=ALL（SELECT GRADE FROM SC WHERE C#=C2）

A、SELECT S# FROM SC WHERE C#='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE C#='C2')

B、SELECT S# FROM SC WHERE C#='C2' AND GRADE >=(SELECT GRADE FROM SC WHERE C#='C2')

C、SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')

D、SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')

假定有三个关系，学生关系S、课程关系C和学生选课关系SC，它们的结构如下： S(S#，SN，Sex，Age，Dept)，C(C#，CN)，SC(S#，C#，Grade)。其中，S#为学生号，SN为姓名，Sex为性别，Age为年龄，Dept为系别，C#为课程号，CN为课程名，Grade为成绩。检索选修课程“C2”的学生中成绩最高的学生的学号，正确的SQL．语句是______。

A．SELECT S#FROM SC WHERE C#="C2" AND Grade IN (SELECT Grade FROM SC WHERE C#="C2")

B．SELECT S# FROM SC WHERE C#="C2" AND Grade＞= (SELECT Grade FROM SC WHERE C#="C2")

C．SELECT S# FROM SC WHERE C#="C2" AND Grade＞=ALL (SELECT Grade FROM SC WHERE C#="C2")

D．SELECT S# FROM SC WHERE C#="C2" AND Gtade NOT IN (SELECT Grade FROM SC WHERE C#="C2")

A、SELECT S# FROM SC WHERE C#='C2' AND GRADE<=(select grade from sc where c#="C2"> B、SELECT S# FROM SC WHERE C#='C2' AND GRADE IN(SELECT GRADE FROM SC WHERE C#='C2')

C、SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN (SELECT GRADE GORM SC WHERE C#='C2')

D、SELECT S# FROM SC WHERE C#='C2' AND GRADE<=all(select grade from sc where c#="C2">

A、SELECT S# FROM SC WHERE C#='C2' AND GRADE >=MAX(SELECT GRADE FROM SCWHERE C#='C2');

B、SELECT S# FROM SC WHERE C#='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE C#='C2');

C、SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2');

D、SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SCWHERE C#='C2');