[简答题]Passage Two
Earthquakes
It was from this trench where the earthquake came, at a magnitude of 8.3 on the Richter scale.
Huge waves swept over the city.

[单项选择]使用如下的SQL语句查询数据库：
SELECT bonus
FROM salary
WHERE bonus BETWEEN 1 AND 250
OR (bonus IN (190, 500, 600)
A. 请问这个SQL语句将返回如下的哪个值100
B. 260
C. 400
D. 600

[单项选择]DBMS的含义是（ ）。有SQL语句： 　　SELECT DISTINCT系号FROM教师WHERE工资＞= ； 　　ALL(SELECT 工资 FROM 教师 WHERE 系号=“02”) 　　该语句的执行结果是系号（ ）。
A. “01”和“02”
B. “01” 和“03”
C. “01”和“04”
D. “02”和“03”

[填空题]逻辑删除职工表中工资在800-1000元之间的全部职工信息。
DELETE FROM 职工 WHERE 工资 【15】 800 AND 1000

[单项选择]

As Texas begins to recover from two weeks of devastating storms, a generally hidden truth about its economy will come to light again. Most of the builders and electricians who will have to repair the houses, remake the roads and re-establish the electrical power lines will have to take on undocumented workers in order to meet their contracts. In 1996 the Immigration and Naturalisation Service (INS) conservatively estimated that Texas had over 600,000 undocumented immigrants doing the jobs no one else wants: hauling carcasses in packing plants, picking fruit, cleaning hotel rooms, or sorting out the unspeakable damage caused by natural disasters.
Mention the issue of these workers to a Texan, and he is liable to fall uncharacteristically silent. Even state legislators avoid the issue. They know that many of their constituents employ undocumented workers. They also know that the booming Texas economy is driven in part by the ready supply of cheap, diligent, illegal labour.<
A. is seen as a problem by local authorities
B. is tolerated given that it helps the local economy
C. can be considered evidence of the failing economy
D. is a source of racial conflict

[单项选择]The owner’s equity in a business comes from two sources: ______.
(1) Investment by the owner
(2) Notes receivable
(3) Earnings from profitable operation of business
(4) Accounts receivable
A. (2) and (4) B. (1) and (3) C. (1) and (2)
B. (3) and (4)

[填空题]检索当前表“学生”表中，全部姓“王”的学生记录，SQL语句为：
SELECT*FROM 学生 WHERE 姓名______"王*/

[单项选择]My grandfather lived only half a mile away from where I grew up in New York. Every day, he would walk down to our house and bring my dad newspapers. Along with the papers he would bring a small bag of treats for my two brothers and me.
Western NY had terrible winter weather: rain, sleet, or even 3 feet of snow. Even when he was 81, he still walked the half mile every single day. As a child, I looked forward to the daily treats, but now I’m older and I realize he braved the rough weather each day just to see us smile; I now value that more than anything else.
My grandfather touched many lives. A woman who had been in hospital for five years told me her story. She said my grandfather would visit her twice a week at her home: to read to her, play bridge, or just chat. It lasted for years without stop. She had few visitors. Even a hitchhiker who my grandfather had picked up for free told me of my grandfather’s influence on his life. My grandfather took the traveler to his
A. bring his son newspapers
B. give his grandsons some food
C. take exercise by walking
D. see his son and grandchildren

[单项选择]The creation of Northern Ireland dates from （　） when the Irish Free State was set up.
A. 1916
B. 1921
C. 1937
D. 1949