问题 单项选择题

设有如下说明,请回答(29)~(35)小题:
有如下3个表:
职员.DBF:职员号C(3),姓名C(6),性别C(2),组号N(1),职务C(10)
客户.DBF:客户号C(4),客户名C(36),地址C(36),所在城市C(36)
订单.DBF:订单号C(4),客户号C(4),职员号C(3),签订日期D,金额N(6.2)

显示没有签订任何订单的职员信息(职员号和姓名),正确的SQL语句是( )。

A.SELECT 职员.职员号,姓名 FROM 职员 JOIN 订单 ON 订单.职员号=职员.职员号 GROUP BY 职员.职员号 HAVING COUNT(*)=0

B.SELECT 职员.职员号,姓名 FROM 职员 LEFT JOIN 订单 ON 订单.职员号=职员.职员号 GROUP BY 职员.职员号 HAVING COUNT(*)=0

C.SELECT 职员号,姓名 FROM 职员 WHERE 职员号 NOT IN(SELECT 职员号 FROM 订单)

D.SELECT 职员.职员号,姓名 FROM 职员 WHERE 职员.职员号<>(SELECT订单.职员号FROM订单)

答案

参考答案:C

解析: 显示没有签订任何订单的职员信息等价于显示订单表中不存在的职员信息。只有选项C符合查询条件。

完形填空
It was very late at night. An old man came to a small town. He found an inn (小旅馆) and Wanted to slay there for the night. After he went to his room, the owner said to his 41   ."Look at hisbag. There must be much money in it. Let’s take it away when he’s 42 , shall we? ’
"Oh, no," said the woman. "He must 43 his bag when he wakes up tomorrow morning. If he can’t find it, he’ll telephone the police."
They thought for a few minutes. Then the woman had an 44 . "We have forgetful grass. Why not put some forgetful grass into his food? If he 45 the food, he will forget lo take his bag away."
The old man ate the food 46 the forgetful grass and went to bed. The next morning when the owner got up, he found the door 47 and the old man had gone away with his bag. He woke his wife up and said to her angrily, "How foolish you are! Your forgetful grass isn’t 48 at all."
"No, I don’t think so. He must forget_49__," his wife said.
"Oh! I remember now! He forgot to 50 for the night," cried out the man suddenly. Then they looked at each other without saying a word.
小题1:
A.sisterB.friendC.auntD.wife
小题2:
A.asleepB.awakeC.aliveD.alone
小题3:
A.set offB.give upC.look forD.take off
小题4:
A.ideaB.adviceC.instructionD.excuse
小题5:
A.eatsB.receivesC.likesD.refuses
小题6:
A.ontoB.forC.withD.into
小题7:
A.openB.opensC.openingD.lo open
小题8:
A.interestingB.importantC.deliciousD.useful
小题9:
A.anythingB.nothingC.somethingD.everything
小题10:
A.spendB.costC.takeD.pay
实验题