【单选题】检索选修课程“ C2 ”的学生中成绩最高的学生的学号。正确的 SELECT 语句是
A.
SELECT S# FORM SC WHERE C#=“C2” AND GRAD>= (SELECT GRADE FORM SC WHERE C#= “ C2 ” )
B.
SELECT S# FORM SC WHERE C#=“C2” AND GRADE IN (SELECT GRADE FORM SC WHERE C#=“C2”)
C.
SELECT S# FORM SC WHERE C#=“C2” AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C#= “ C2 ” )
D.
ELECT S# FORM SC WHERE C#=“C2” AND GRADE>=ALL (SELECT GRADE FORM SC WHERE C#= “ C2 ” )
【多选题】有关组织含义的表述,正确的是( )。
E.
没有不同层次的权力和责任制度就不能实现组织活动和组织目标
【单选题】理想的评价量表是一种制作( )的直接方法。
【简答题】老约翰斯特劳斯最为著名的乐曲(进行曲)是 。
【单选题】检索选修课程“ c2 ”的学生中成绩最高的学生的学号。正确的 select 语句是
A.
select sno from sc where cno=’c2’ and grade >= (select grade from sc where cno=’c2’)
B.
select sno from sc where cno=’c2’ and grade in (select grade from sc where cno=’c2’)
C.
select sno from sc where cno=’c2’ and grade not in (select grade from sc where cno=‘c2’)
D.
select sno from sc where cno=’c2’ and grade>=all (select grade from sc where cno=‘c2’)
【多选题】毕业答辩前学生( )是顺利完成答辩的条件。
【单选题】检索选修课程”C2”的学生中成绩最高的学生的学号。正确的SELECT 语句是
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 FROM SC WHERE C#= “C2”)
D.
SELECT S# FROM SC WHERE C#=”C2” AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C#= “C2”)