问题 单项选择题

设Student为学生关系,SC为学生选课关系,Sno为学生号,Sname为学生姓名,Cno为课程号,执行下列SQL语句的查询结果是( )。
Select Student.Sname
From Student,SC
Where Student.Sno=SC.Sno
And SC.Cno='C1'

A.选出选修C1课程的学生信息

B.选出选修C1课程的学生姓名

C.选出Student中学生号与SC中学生号相等的信息

D.选出Student和SC中的一个关系

答案

参考答案:B

解析: 在SQL的查询语句中,Select子句用于指定最后结果中的字段,Where子句用于指定查询条件,只有满足条件的元组才会出现在结果中。对于本题来说,由于Select子句后面是Student.Sname,故此查询结果只有学生名;Where子句中首先将Student.Sno和Se.Sno相等的筛选出来,是为两表连接;并且条件SC.Cno='C1'限定了选修的课程号为C1。

判断题
阅读理解

阅读理解(满分40分)

第一节(共15小题年每小题2分,满分30分)

请阅读下列短文,从每题所给的四个选项(A、B、C、D)中,选出最佳答案,并在答题卡上将该选项的标号涂黑。

A

When I was a child, I often dreamed of the time when I could leave home and escape to the city. We lived on a farm, in the winter especially, we wear quite out off from the outside world. As soon as I left school, I packed my bags and moved to the capital.

However, I soon discovered that one big disadvantage is money. It costs so much to go out, not to mention basics like food and housing. Another disadvantage is pollution. I suffer from asthma(哮喘), and  the air is so bad that I am afraid to go outside. Then there is the problem of traveling round. Although I have a car, I seldom use it became of the traffic jams. One choice is to go by bicycle, but that can be quite dangerous.

Of course there are advantages. First, there is so much to do in the city, whatever you tastes in culture or entertainment(娱乐活动). Besides, there are wonderful jobs and greater chances of moving to a more important job or position. Finally, if you like shopping, the variety of goods is very surprising --- and , what is more, shops are often only a short walk away.

Is life better then, in the city? Perhaps it is , when you are in your teens(十几岁)or twenties. However, as you get older, and especially if you have small children, the peace of the countryside may seem preferable. I certainly hope to move back there soon.

61. What was the writer always thinking about when he was a child?

A. Staying on the farm.                B. Moving to the countryside.

C. Leaving home for the city.           D. Running away from the school.

62. Which of the following is true about the writer?

A. He is very old now.                 B. He is in good health.

C. He prefers driving a car.             D. He lives in the city now.

63. In the passage, the writer tries to __________.

A. express his opinions about way of life      B. describe his life in the countryside

C. an interest in the outside world            D. persuade the reader to live in the city

64. How is the passage mainly developed?

A. By inferring.         B. By comparing.       

C. By listing examples.   D. By giving explanations.