Which is the right order of what happened? ( )a.My family moved from Russia to the U. S. A

题目

Which is the right order of what happened? ( )

a.My family moved from Russia to the U. S. A.

b. I met Larry Page.

c. I was given a computer as a birthday present.

d.Google was born in an ordinary garage in California.

e.I graduated from the university in Mathematics and IT.

A. a-c-e-b-d

B. c-a-b-e-d

C. a-c-b-d-e

D. c-b-a-e-d

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是A)SELECT S.学号,姓名,平均成绩FROM S,SC; WHERE S.学号=SC.学号; GROUP BY S.学号HAVING GOUNT(*)>=5 ORDER BY平均成绩DESCB)SELECT学号,姓名,AVG(成绩)FROM S,SC; WHERE S.学号SC.学号AND COUNT(*)>=5; GROUP BY学号ORDER BY 3 DESCC)SELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC; WHERE S.学号=SC.学号AND COUNT(*)>=5; GROUP BY S.学号ORDER BY平均成绩DESCD)SELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC; WHERE S.学号=SC.学号; GROUP BY S.学号HAVING COUNT(*)=5 ORDER BY 3 DESC


正确答案:D
本题考查使用COUNT()函数来构造复杂查询,显示”平均成绩”不是表中字段,不能直接显示,用函数来实现表示方法为:AVG(成绩)平均成绩。因选项A,选项B表示错误可排除;在查询中是先用WHERE子句限定元组,然后进行分组,最后再用HAVING子句限定分组,也就是说先写WHERE子句,然后是GROUP,最后用HAVING子句对GROUP分组限定条件。选项C这两个选项中错误在于COUNT(*)>=5分组限定条件写在WHERE之后。故选项D为正确答案。

第2题:

Nothing shall _________ us from doing what we think right.

Aprefer

Btriple

Ccrave

Ddeter


参考答案:D

第3题:

Which is the right order of what happened?

A. My family moved from Russia to the U. S. A.

b. I met Larry Page.

c. I was given a computer as a present on my 9th birthday.

d. Google was born in an ordinary garage in California.

e. I graduated from the university in Mathematics and IT.

A. a-c-e-b-d

B. c-a-b-e-d

C. a-c-b-d-e

D. c-b-a-e-d


正确答案:A
a发生在5岁的时候,b发生在读博士期间,c发生在9岁的时候,d发生在和搭档放弃读博学业之后,e发生在本科毕业的时候。梳理一下事件发生的顺序知道答案选A。

第4题:

—These days Mr. Smith looks anxious and restless. What happened? —I heard his wife was in the family way this month.()

A.pregnant

B.badly sick

C.dead

D.married


正确答案:A
解析:本句参考译文:——最近史密斯先生看起来焦虑不安。他怎么了?——听说他太太这个月刚刚怀孕了。【知识点来源:Unit 3】 本题考查英语单词family的内涵意义。in the family way 是英语中的习语(idiom),意思是“怀孕”。

第5题:

We haven't heard from Jane for along time.-What____to her?

A)was happening

B)to happen

C)has happened

D)having happened


参考答案:C

第6题:

查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。

A) SELECT SNAME,AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE

c.c# ='MATHS ')

B ) SELECT SNAME, AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE

SC. C# =' MATHS ')

C) SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'

ORDER BY S. S#

D)SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'


正确答案:A
有两种方式进行题干所述的查询:连接查询方式和带嵌套的简单查询方式。连接查询方式是在表‘S和SC中按照S.S#=SC.S#和SC.C#=‘MATHS’的条件查找。带嵌套的简单查询方式是先只查询S表,在WHERE子句中限定“选修了课程号为‘MATHS’”…。WHERE子句中又带简单查询的SELECT语句,为SELECT SC.S#FROM SC WHERE SC.C#=‘MATHS’,即在SC表中按SC.C#=‘MATHS'的条件查找。 

第7题:

We didn't know what had happened to her until we () the accident in the newspaper.

A、read

B、read of

C、read over

D、read from


参考答案:B

第8题:

用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。

A.SELECT S.学号,姓名,平均成绩 FROM S,SC;

WHERE S.学号=SC.学号;

GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 平均成绩 DESC

B.SELECT 学号,姓名,AVG(成绩) FROM S,SC;

WHERE S.学号=SC.学号AND COUNT(*)>=5;

GROUP BY 学号 ORDER BY 3 DESC

C.SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;

WHERE S.学号=SC.学号AND COUNT(*)>=5;

GROUP BY S.学号 ORDER BY 平均成绩 DESC

D.SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;

WHERE S.学号=SC.学号;

GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 3 DESC


正确答案:D

第9题:

What is the purpose of the FOMC meeting?

A.Making decisions on investment portfolio of the FRB

B.Making decisions on monetary policy.

C.Making decisions on fiscal policy.

D.Making decisions on exchange rate of U. S. dollar.


正确答案:B
解析:录音原文提到At these meetings the FOMC members decide…be changed联邦公开市场操作委员会成员在会议上商榷货币政策是否应该改变。

第10题:

查询选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是

A.SELECT s.学号,姓名,平均成绩FROM student s,score sc WHERE s.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5 ORDER BY平均成绩DESC

B.SELECT学号,姓名,AVG(成绩)FROM student s,score sc WHERE s.学号=sc.学号AND COUNT(*)>=5 GR0UP BY学号ORDER BY 3 DESC

C.SELECT s.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc wHERE s.学号=sc.学号AND COUNT(*)>=5 GROUP BY s.学号ORDER BY平均成绩DESC

D.SELECT s.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc WHERE s.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5ORDER BY 3 DESC


正确答案:D
解析:HAVING短语必须跟随GROUP BY使用,它用来限定分组必须满足 的条件,所以本题正确答案为D。

更多相关问题