问题 单项选择题

某超市的商品(商品号,商品名称,生产商,单价)和仓库(仓库号,地址,电话,商品号,库存量)两个基本关系如表1和表2所示。

A.仓库关系的主键是(),该关系没有达到第三范式的原因是();

B.查询联想生产的激光打印机的总库存量的SQL语句如下:

SELECT 商品名称,()

FROM商品,仓库

WHERE () AND ();

C.若仓库关系的地址不能为空,请将下述仓库关系SQL语句的空缺部分补充完整。

CREATE TABLE仓库(仓库号CHAR(2),

地址 CHAR(20) (),

电话 CHAR(20),

商品号 CHAR(5),

库存量 NUMERIC(5),

(),

();

SELECT 商品名称,()。

A.NUMBER(库存量)

B.SUM(库存量)

C.COUNT(库存量)

D.TOTAL(库存量)

答案

参考答案:B

解析:

正确的答案分别是B、C和B,因为查询联想生产的激光打印机的总库存量的SQL语句如下:

SELECT 商品名称,SUM(库存量)

FROM 商品,仓库

WHERE 生产商=’联想’

AND 商品名称=’激光打印机’AND商品.商品号=仓库.商品号;

单项选择题

This was one of my experiences (1) . When I was in my 30s, I was working for a large international company which had its head office in London. I was working in the (2) department.

The company had a training centre which was just outside London. Different courses were held there throughout (3) and I (4) go on one training course a year. These usually started (5) a Sunday evening and lasted six days.

Once I was (6) a week’s training course with about forty (7) sales people. I was in the bar on the Friday evening and suddenly a woman who was (8) behind the bar asked mea curious question. "I hope you don’t (9) my asking," she said, "but I’ve been (10) about it all week. Have you got a sister (11) Mary" The woman’s name was June. And she used to do various jobs at the training centre. She worked in the office, she organized all the food and drink for the centre and she worked in the bar at lunchtime and in the evening.

My answer (12) June’s question was "Yes", and June said, "I thought (13) . I met her last September when she was organizing a course here. " At that time, my sister was working for (14) company but in a different part of the country. That was (15) she came to be at the training centre.

(16) surprised me was how June guessed we were brother and sister. Three things made it even more (17) . First, she had met my sister six months before she met me. Second, they have about sixty new people every week at the training centre. So about one thousand five hundred people had (18) the centre in those six months. And (19) , my sister is married, so she doesn’t have the same family name as me.

We’re not (20) , but I guess we must look quite like each other.

1().

A.in work

B.out of work

C.at work

D.about work

单项选择题