changes
alters
ranges
limits
第1题:
There are students in Class One than in Class Two.
A、 many
B、 more
C、 most
答案:B
解析:本句意思:一班的学生比二班的多,句子中than说明两项内容进行比较,所以用比较级,而选项A是原级,选项C是最高级,所以应选B
第2题:
根据SQL标准,要查询表student中平均年龄age小于21的所在系dept及其平均年龄值,下面哪条语句适用?()
A select dept,avg(age) from student where avg(age)<21
B select dept,avg(age) from student group by dept having avg(age)<21
C select dept,avg(age) from student having avg(age)<21
D select dept,avg(age) from student group by dept where avg(age)<21
第3题:
根据SQL标准,下面哪条语句与select min(age) from student等效?()
A select age from student where age >= min(age)
B select distinct age from student where age >= all min(age)
C select distinct a.age from student a where a.age<= any (select distinctb.age from student b)
D select distinct a.age from student a where a.age<= all (select distinct b.age from student b)
第4题:
现有3个表Students(SID,SN,SEX,AGE,DEPT),Courses(CID,CNAME),SCORE(SID,CID,GRADE)。 其中,SID为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,CID为课程号,CNAME为课程 名,GRADE为成绩。检索“王华”同学所选修的课程名称和成绩,正确的SELECT语句是( )。
A. SELECT CNAME,GRADE FROM Students INNER JOIN SCORE ON Students.SID=SCORE.SID INNER JOIN Courses ON SCORE.CID=Courses.CID WHERE SN=’王华’
B. SELECT CNAME,GRADE FROM Students INNER JOIN Courses ON Students.SID=Courses.CID WHERE SN=’王华’
C. SELECT CNAME,GRADE FROM SCORE INNER JOIN Courses ON SCORE.CID=Courses.CID WHERE CNAME=。王华。
D. SELECT CNAME,GRADE FROM Students INNER JOIN Courses ON Students.SN=Courses.CNAME WHERE SN=’王华。
第5题:
From the last paragraph we know that in Brazil______.
A. it is important to arrive at the appointed time
B. it is rude for professors to be late for class
C. it is normal for students to leave during lectures
D. it is natural to keep the professor staying after class
54.答案为D 最后一段谈到的是巴西学生不仅迟到,而且下课后不离开,继续让教授解答问题,A、B、C选项都与本段无关。
第6题:
第7题:
第8题:
第9题:
下列SQL语句中,能够完成求某列最大值的是()。
第10题:
changes
alters
ranges
limits
第11题:
SELECT*FROM students ORDERBYavg_grade
SELECT*FROM students GROUPBYavg_grade ASC
SELECT*FROM students ORDERBYavg_grade DESC
SELECT*FROM students ORDERbyavg_gradeasc
第12题:
don’t give
aren’t given
haven’t given
won’t give
第13题:
A.other
B.others
C.the others
D.the other
第14题:
根据SQL标准,下面哪句语句能够找出年龄最小的同学?其中age为学生表student中的年龄字段,sno为学生的学号。()
A select max(age) from student
B select sno from student where age = max(age)
C select sno from student having age = max(age)
D select sno from student a where a.age<= (select min(b.age) from student b)
第15题:
Most students in this class ( ) from the countryside.
A.is
B.are
C.will
D.would
第16题:
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
A.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN='王华')
B.SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C.SELECT SN,AGE, SEX FROM S WHERE AGE>(SELECT AGE WHERE SN='王华')
D.SELECT SN,AGE,SEX FROM S WHERE AGE>王华 AGE
第17题:
What is the main idea of this passage?
A. It is important to be on time for class in the United States.
B. The importance of being on time differs among cultures.
C. People learn' the importance of time from the culture they are in.
D. Students being late for class should explain the reason to their teacher.
55.答案为B 从文章中教授的经历和调查可得知守时的重要性在不同文化中的差异,因此B为正确答案。
第18题:
第19题:
第20题:
下列SQL语句中,能够完成求某列最大值的是()。
ASELECT AVG(Age) FROM Student
BSELECT MAX(Age) FROM Student
CSELECT MIN(Age) FROM Student
DSELECT COUNT(*) FROM Student
第21题:
Chuck’s students are not clever enough
the students didn’t do Chuck’s homework
Chuck Wall is an unusual teacher
no students enjoyed Chuck’s homework
第22题:
44
40
32
28
26
第23题:
with regard to
in the light of
in proportion to
on account of
第24题:
5.3
5
4
6
5.5