计算机系和教务处要对某数据库进行访问，计算机系全体教师对此数

问题单项选择题

计算机系和教务处要对某数据库进行访问，计算机系全体教师对此数据库中的全部数据具有查询权，教务处全体人员对此数据库中全部数据具有查询、插入、删除和修改权。在SQL Server 2000中，下列安全控制方法最合理的是（）。

A．为计算机系每个教师授予每个表的SELECT权，为教务处全体人员授予每个表的SELECT、INSERT、DELETE和UPDATE权

B．为计算机系和教务处分别建立一个角色，将两个部门的每个职工设置为相应角色中的成员。将计算机系角色和教务处角色设置为此数据库的db_datareader角色中的成员，将教务处角色设置为此数据库的db_datawriter角色中的成员

C．为计算机系和教务处分别建立一个角色，将两个部门的每个职工设置为相应角色中的成员。为计算机系角色授予每个表的SELECT权，为教务处角色授予每个表的SELECT、INSERT、DELETE和UPDATE权

D．将计算机系和教务处的每个职工都设置为db_owner角色中的成员

答案

参考答案：B

解析：

为便于管理，可将老师和教务处人员设置为固定的数据库角色成员，其中dh_datareader角色可以查询数据库中所有用户表中的数据，db_datawriter角色可以更改数据库中所有用户表中的数据。

完形填空。
Soccer ball is another(另一种)way of saying __1__. Jim is a football fan(足球迷). He __2__ playing football. He is also __3__ at football. Ronaldo is his __4__ football player.Jim is 5 _ the school football team(队). Every Friday afternoon he plays football __6__ his friends. Jim also likes __7__ the football matches(比赛) __8__ TV. Jim’s friend Mike doesn’t like football, __49___ he likes basketball very much. Michael Jordan is his favorite baskrtball __10__. Mike is on the school __11___ team. They play basketball __12__ Wendesday afternoon. He often __13 _ the basketball __14__ on TV, __15__.
( )1. A. tennis ( )2. A. like ( )3. A. good ( )4. A. like ( )5. A. at ( )6. A. and ( )7. A. watch ( )8. A. at ( )9. A. and ( )10. A. teacher ( )11. A. tennis ( )12. A. in ( )13. A. watch ( )14. A. matches ( )15. A. to	B. volleyball B. likes B. well B. favorite B. in B. or B. watches B. in B. or B. player B. volleyball B. on B. watches B. matching B. too	C. football C. thinks C. bad C. love C. on C. with C. watching C. on C. with C. actor C. football C. at C. watching C. match C. also	D. basketball D. think D. badly D. good D. join D. but D. watched D. with D. but D. runner D. basketball D. but D. watched D. matched D. please