对于关系模式S（Sno，Sname，Age，Dept），C（Cno，Cname，Teacher），SC（Sno，Cno，Score），下列查询结果相同的是（ ）。I．πSname((S) ∞σScore>60(SC)) II．πSname(σScore>60(S∞SC)) III．σScore>60 (πSname (S∞ SC)) IV．σScore>60 (πSname (S)∞ (SC)) A: I与II B: III与IV C: I与III D: II与IV

---Our monitor is really into Jay Zhou's music.He has at least_______ Jay Zhou's CDs.--- No wonder he can sing every single song of Jay Zhou's very well. A: three scores of B: three score of C: three score D: score of

A．SELECT Cno, AVG(Score) FROM SCS GROUP BY Score ORDER BY 2, Cno Desc B．SELECT Cno, AVG(Score) FROM SCS GROUP BY Cno ORDER BY 2, Cno Desc C．SELECT Cno, AVG(Score) FROM SCS WHERE Cno, Desc GROUP BY Score D．SELECT Cno, AVG(Score) FROM SCS GROUP BY, AVG(Score) ORDER BY, Cno Desc

有关系表SC(S# , C#, Score),求“001”号课成绩比“002”号课成绩高的所有学生的学号。下列SQL语句正确的是_________。[br][/br](单选题) A: Select S1.S B: From SC S1, SC S2 Where S1.S C: = S2.S D: and S1.C E: =‘001’ and S2.C F: =‘002 ; G: Select S1.S H: From SC S1, SC S2 Where S1.S I: = S2.S J: and S1.C K: =‘001’ and S2.C L: =‘002’ and S1.Score > S2.Score; M: Select S1.S N: From SC S1, SC S2 Where S1.S O: = S2.S P: and S1.C Q: =‘001’ and S2.C R: =‘002’ and S2.Score > S1.Score; S: Select * From SC S1, SC S2 Where S1.S T: = S2.S U: and S1.C V: =‘001’ and S2.C W: =‘002’ and S1.Score > S2.Score;

以下关于结构体数组和结构体元胞数组的语句中，正确创建结构体元胞数组的是 A: data.name='张三'; data.score=87;data.name='李四'; data.score=65; B: data(1).name='张三'; data(1).score=87;data(2).name='李四'; data(2).score=65 C: data[1].name='张三'; data[1].score=87;data[2].name='李四'; data[2].score=65; D: data{1}.name='张三'; data{1}.score=87;data{2}.name='李四'; data{2}.score=65;

Mary’s score on the test is the highest in her class; She____have studied very hard.

59（） A: everything is wrong B: Do you agree C: let’s total the score D: let’s do it E: we can do it F: Here is the answer sheet G: Here is your score H: the percentage is incorrect

What is NOT true to that World Cup(). A: It was held in 1986. B: The disputed goal occurred in the quarterfinals. C: The score between Argentina and England was 2 to 1. D: Argentina eventually lifted the World Cup with the score of 2 to 1.

关系SC(S，SNAME，SEX，SCORE，CNAME)，从关系SC中检索男生(SEX =M)并且成绩大于等于60的学生姓名，下述表示( )是正确的。 Ⅰ．ЛSNAME(σSCORE＞60□SEX=’M’(SC)) Ⅱ．σSCORE＞=60□SEX=’M’(ЛSNAME(SC)) Ⅲ．ЛSNAME(σSCORE＞=60□SEX=’M’(ЛSNAME，SCORE，SEX(SC))) A: Ⅰ和Ⅱ B: Ⅱ C: Ⅰ和Ⅲ D: Ⅰ

从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： A: select name, age, score from student order by age desc , score; B: select name, age, score from student order by age , score asc; C: select name, age, score from student order by 2 desc , 3 asc; D: select name, age, score from student order by 1 desc , 2；