A group of ________will come to our school tomorrow.A.GermanyB.GermansC.GermanD.Japanese

A.给owner和group增加w权限

B.给owner、group和others用户增加w权限

C.给没有w权限的用户增加w权限

D.给默认用户增加w权限

A. membership query message

B. membership report message

C. leave group message

D. source filtering

E. destination filtering

标准SQL基本查询模块的结构是 ______。

A．SELECT…FROM…ORDER BY

B．SELECT…WHERE…GROUP BY

C．SELECT…WHERE…HAVING

D．SELECT…FROM…WHERE

A.Value contract for material 4711 SRM central contract with item category M (material unknown) for 100 tons of copier paper of material group 4711

B.Quantity contract for over 500 pallets of copier paper for a stock material that belongs to material group 4711

C.Value contract with item category W (material group) for articles of material group 4711

A.A value contract item with item category W (material group) for articles of material group 4711

B.An info record for material without a master record for copy paper of material group 4711 with tons as the unit of measurement

C.A quantity contract item with standard item category for 500 pallets of copy paper for a stock material that belongs to material group 4711

D.A quantity contract item with item category M (material unknown) for 500 pallets of copy paper of material group 4711

在SQL语言的SELECT语句中，用于对结果元组进行分组的是（）子句。

A）GROUP BY

B）HAVING

C）ORDER BY

D）WHERE

某数据库中有员工关系E、产品关系P、仓库关系W和库存关系I，其中：

员工关系E(employeelD，name，department)中的属性为：员工编号，姓名，部门；

产品关系P(productID，name，model，size，color)中的属性为：产品编号，产品名称，型号，尺寸，颜色；

仓库关系W(warehouselD，name，address，employeeID)中的属性为：仓库编号，仓库名称，地址，员工编号；

库存关系I(warehouseID，productID，quantity)中的属性为仓库编号，产品编号和产品数量。

a．若要求仓库关系的负责人引用员工关系的员工编号，员工关系E的员工编号、仓库关系W的仓库编号和产品关系P的产品编号不能为空且惟一标识一个记录，并且仓库的地址不能为空，则依次要满足的完整性约束是___(10)___。

b．可得到每种产品伪名称和该产品的总库存量的查询语句为；

SELELCT name，SUM(quantity)

FROM P,I

WHERE___(11)___

(10)A．实体完整性、参照完整性、用户定义完整性

B．参照完整性、实体完整性、用户定义完整性

C．用户定义完整性、实体完整性、参照完整性

D．实体完整性、用户定义完整性、参照完整性

(11)A．P.productID=I.productlD；

B．P.productID=I.product ID ORDER BY name；

C．P.productID=I．product ID GROUP BY name；

D．P.productID=I．product ID GROUP BY name，quantity。

试题（6）、（7）

某数据库中有员工关系E（员工号，姓名，部门，职称，月薪）；产品关系P（产品号，产品名称，型号，尺寸，颜色）；仓库关系W（仓库号，仓库名称，地址，负责人）；库存关系I（仓库号，产品号，产品数量）。

a. 若数据库设计中要求：

① 仓库关系W中的“负责人”引用员工关系的员工号

② 库存关系I中的“仓库号，产品号”惟一标识I中的每一个记录

③ 员工关系E中的职称为“工程师”的月薪不能低于3500元

则①②③依次要满足的完整性约束是 （6） 。

（6）

A. 实体完整性、参照完整性、用户定义完整性

B. 参照完整性、实体完整性、用户定义完整性

C. 用户定义完整性、实体完整性、参照完整性

D. 实体完整性、用户定义完整性、参照完整性

b. 若需得到每种产品的名称和该产品的总库存量，则对应的查询语句为：

SELELCT 产品名称, SUM(产品数量)

FROM P, I

WHERE P.产品号 = I.产品号 （7） ;

（7）

A. ORDER BY产品名称

B. ORDER BY 产品数量

C. GROUP BY产品名称

D. GROUP BY 产品数量

某数据库中有员工关系E(员工号，姓名，部门，职称，月薪)；产品关系P(产品号，产品名称，型号，尺寸，颜色)；仓库关系W(仓库号，仓库名称，地址，负责人)；库存关系I(仓库号，产品号，产品数量)。

若需得到每种产品的名称和该产品的总库存量，则对应的查询语句为：

SELECT产品名称, SUM(产品数量)

FROM P, I

WHERE P. 产品号=I.产品号 ______;

A．ORDER BY产品名称

B．ORDER BY产品数量

C．GROUP BY产品名称

D． GROUP BY产品数量

W: Why don't you try house-sitting？ Last summer Cindy was a house sitter for the Smiths when they went away on vacation. They hired Cindy to stay in their house because they didn't want it left empty.

M: You mean they paid Cindy just to live in their house？

W: It wasn't that easy. She had to water the house plants, mow the lawn, and even take care of the pets.

M: I guess it is a little like baby-sitting, except you're taking care of a house instead of children.

W: The student employment office still has a few jobs posted.

M: Do I just have to fill oat an application？

W: You have to have an interview with the homeowner and provide three references at least.

M: That seems like a lot of trouble for a summer job.

W: Well, the homeowner wants some guarantee that they can trust the house sitter. You know they want to make sure you're not the type who'll hold wild parties in their house, or bring a group of friends in with you.

M: I see. House sitters who do that sort of thing probably aren't paid then.

W: Usually they're paid anyway just because the homeowners don't want to make a fuss. But if the homeowner reports it, the house sitter won't be able to get another job easily. So why don't you apply？

M: I think I will. Thank you.

(20)

A．They left their pets with neighbors.

B．They rented their house to a student.

C．They hired someone to stay in their home.

D．They asked their gardener to watch their house.

假设供应商S和供应情况SPJ的关系模式分别为：S(Sno，Sname，Status，City)和SPJ(Sno，Pno，Jno，Qty)。SQL语句(22)不能正确地查询出“零件号Pno等于‘P3’的供应商名Sname"，而(23)．能正确查询的关系代数表达式。

A．SELECT DISTINCT Sname

B．SELECT DISTmCT Sname FROMS FROMS WHERE EXISTS WHERE 0＜(SELECT *(SEIECT COUNT(*)FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE

C．SELECT Sname

D．SELECT Sname FROMS FROMS, SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno(SELECT * AND SPJ.Pno= 'P3')FROM SPJ GROUP BYSname W