使用如下数据表：仓库表(仓库号，所在城市) 职工表(职工号，_爱下问搜题

搜题请搜索小程序“爱下问搜题”

问题单项选择题

使用如下数据表：
仓库表(仓库号，所在城市)
职工表(职工号，仓库号，工资)
其中，仓库号、所在城市和职工号字段为字符型，工资字段为数值型。

若仓库表和职工表中有如下记录：
仓库表仓库号所在城市
A1 北京
A2 上海
A3 天津
A4 广州
职工表职工号仓库号工资
M1A1 2000.00
M3A3 2500.00
M4A4 1800.00
M5A2 1500.00
M6A4 1200.00
有如下SQL语句：
SELECT SUM(工资)FROM 职工表 WHERE 仓库号 IN；
(SELECT 仓库号 FROM 仓库表 WHERE 所在城市="北京" OR 所在城市："上海")
执行语句后，工资总和是

A. 3500.00
B. 3000.00
C. 5000.00
D. 10500.00

答案

参考答案：A

解析：本题SQL查询语句的功能是统计在北京和上海仓库工作的职工的工资总和。

单项选择题

有关问诊错误的是

A．最好病人自己叙述病史
B．态度要求亲切和蔼
C．先问病人容易回答的问题
D．边问边观察病人
E．对危重病人一定要详细询问和检查后再进行抢救

完形填空

阅读下面短文，掌握其大意，然后从36---55各题后的 A B C D四个选项中选出可以填入空白处的最佳选项。
Childish Voice
When I was a young child, my parents often told me that it was time to teach a man everything. I didn’t understand and wondered why   36  had such a big influence   37  a person. I thought I could grow up quickly to find it out as an adult．But now,   38   I come to knock at the door of adulthood, I feel   39 to express my own 40   on this saying. I know that I’m just a high school student with very   41  experiences. There are still many things   42  me in the future, yet I would like to express myself in a childish voice.
I once read this sentence: “To make this world a happy place to live, you’d better   43  yourself and your heart , instead of the whole world.” I was shocked. It made me think about life   44  . There are so many things around us that    45   our will. We can’t force life    46   our wishes. The earth won’t stop turning no matter whether we   47  it or not. What we can do is just to make ourselves 48  the world. I think we should learn to accept   49  life gives us, no matter whether it’s the spring sunlight or the winter snowfall, and try to be happy.
Deeply moved by the pop song Grandmother (by Jay Chou), I always try to 50  every pleasant thing in my life, but now I see I don’t catch most of the pleasant moments. It is more   51  that they slip by and leave you feeling   52  . I realize that I’m not just living   53  myself and that there are the others around me I should think of .They all pay attention to my growing up, even if it’s just a little progress.
Everyone has his or her own attitude towards life, be it positive or   54  .It doesn’t matter, I think. There is one   55  that should be obeyed—and that’s to make this world better.

C．confidences

D．expressions

A．waiting for

B．sticking with

C．dealing with

A．being followed

B．to be followed