【单选题】已知关系模式:SC(sno,sname,grade),各属性含义依次为学号、课程名、分数。要查找“数据库”课分数最高的学生的学号,正确的SQL语句是( )。
A.
SELECT sno FROM sc WHERE sname='数据库'AND grade=MAX(grade)
B.
SELECT sno FROM sc FOR sname='数据库'OR grade>=MAX(grade)
C.
SELECT sno FROM sc WHERE sname='数据库'AND grade=(SELECT MAX(grade)FROM Sc.
D.
SELECT sno FROM sc FOR sname='数据库'OR grade=(SELECT MAX(grade)FROM s
【单选题】已知关系模式:sc(sno,sname,grade),各属性含义依次为学号、课程名、分数。要查找“数据库”课分数最高的学生的学号,正确的SQL语句是( )。
A.
SELECT sno FROM sc WHERE sname='数据库'AND grade=MAX(grade)
B.
SELECT sno FROM sc FOR sname='数据库'OR grade>=MAX(grade)
C.
SELECT sno FROM sc WHERE sname='数据库'AND grade=(SELECT MAX (grade) FROM Sc.
D.
SELECT sno FROM sc FOR sname='数据库' OR grade=(SELECT MAX (grade) FROM Sc.
【简答题】二、完形填空(30分) Everybody knows Charlie Chaplin,a world-famous funny actor.People 21have laughed at Charlie Chaplin’s films 22 tears run down their faces.From his very first 23 they know what will happen....
【单选题】已知关系模式:sc(sno, sname, grade),各属性含义依次为学号、课程名、分数。要查找“数据库”课分数最高的学生的学号,正确的SQL语句是
A.
SELECT sno FROM sc WHERE sname='数据库' AND grade=MAX(grade)
B.
SELECT sno FROM sc FOR sname='数据库' OR grade>=MAX(grade)
C.
SELECT sno FROM sc WHERE sname='数据库' AND grade=(SELECT MAX(grade) FROM sc
D.
SELECT sno FROM sc FOR sname='数据库' OR grade=(SELECT MAX (grade) FROM sc
【单选题】已知关系模式:sc(sno,sname,grade),各属性含义依次为学号、课程名、分数。要查找“数据库”课分数最高的学生的学号,正确的SQL语句是( )。
A.
SELECT sno FROM sc WHERE sname='数据库'AND grade=MAX(grade)
B.
SELECT sno FROM sc FOR sname='数据库'OR grade>=MAX(grade)
C.
SELECT sno FROM sc WHERE sname='数据库'AND grade=(SELECT MAX(grade) FROM SC)
D.
SELECT sno FROM sc FOR sname='数据库'OR grade=(SELECT MAX(grade) FROM Sc)
【简答题】阅读下列JSP代码片断:
x=,
其运行结果是A. x=3,6 B. x=3,4 C. x=5,4 D. 编译错误
【单选题】阅读下列JSP代码片断: x=, 其运行结果是