|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-03-21 09:10:22), 站内信件 |
| 106. You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named SalesData. This table stores information about sales orders that is used to create sales reports and to calculate commissions for sales personnel. The permissions on the SalesData table are configured as shown below:
Users/Database Role Select Insert Update Delete Reporters Grant Blank Blank Blank SalesManagers Grant Grant Grant Grant Salespeople Blank Grant Blank Blank Guest Blank Blank Blank Blank Sales managers monitor the entries made by sales personnel and correct any errors. Because monitoring is time-consuming, the sales department will hire several assistants. The sales managers will make necessary corrections on hard copy, and then the assistants will enter the changes in the table. However, the assistants must not be allowed to delete any data from the table. You need to configure permissions on the table to support these requirements. You also want to reduce the amount of time needed to manage these permissions. What should you do? A. Create a database user account for each assistant. Add each database user account to the SalesManagers database role. Revoke DELETE permissions for the SalesManagers database role. B. Create a single database user account for all assistants. Add the database user account to the SalesManagers database role. Revoke DELETE permissions for the SalesManagers database role. C. Create a database user account for each assistant. Create a database role named SalesAssistants. Grant SELECT, UPDATE, and INSERT permissions to the SalesAssistants database role. Add each database user account to the SalesAssistants database role. D. Create a database user account for each assistant. Create a database role named SalesAssistants. Add the role to the SalesManagers database role. Add each database user account to the SalesAssistants database role. Revoke DELETE permissions for the SalesAssistants database role. Answer: C Reason: 107. You are the administrator of a SQL Server 2000 computer. The server belongs to a Microsoft Windows NT domain named DOMAIN1. The server contains a database named SalesData. Julia is a sales representative who uses the database. You create a login named DOMAIN1\Julia and manually configure the permissions necessary for her to perform her job. Julia is temporarily reassigned to the marketing department. During her assignment in the marketing department Julia must not be able to access the server. However, you must restore her access when she returns to the sales department. You need to configure the appropriate database permissions for Julia. Which Transact-SQL statement should you execute? A. REVOKE ALL TO SalesData FROM 'Julia' B. EXEC sp_revokeaccess 'Julia' C. EXEC sp_denylogin 'Julia' D. EXEC sp_droplogin 'Julia' Answer: C Reason: A选项使得Julia仍然可以登陆服务器，排除！B选项错误，没有这个存储过程，只有sp_revokedbaccess。D选项，删除了安全账号，不利于恢复，排除。 108. You are the administrator of a SQL Server 2000 computer named ProdSql1. The server is a member of a Microsoft Windows NT domain named CORP. ProdSql1 contains a database named Finance. Your company purchases a client/server application that will use a database named Marketing. This database will be stored on ProdSql1. Maria, Byrno, and Stefan will use the new application. These users belong to a domain user group named Marketers. In the future, several additional users who will also use the new application will be added to the Marketers group. The logins on ProdSql1 are configured as shown below: Name Type Server Access BUILTIN\Administrators Windows Permit Sa Standard Permit CORP\Martha Windows Permit CORP\Byron Windows Permit CORP\Sal Windows Permit Marketers Standard Permit You need to allow Martha, Byron, and Sal access to the Marketing database as quickly as possible. Which batch of Transact-SQL statements should you execute? A. USE Marketing GO EXEC sp_grantdbaccess 'CORP\Martha' EXEC sp_grantdbaccess 'CORP\Byron' EXEC sp_grantdbaccess 'CORP\Sal' B. EXEC sp_grantlogin 'CORP\Marketers' GO USE Marketing EXEC sp_grantdbaccess 'CORP\Marketers' C. USE Marketing GO EXEC sp_grantdbaccess 'Marketers' D. EXEC sp_addlogin 'CORP\Marketers' GO USE Marketing EXEC sp_grantdbaccess 'CORP\Marketers' Answer: B Reason: 注意B和D的差异，一个是sp_grantlogin，另外一个是sp_addlogin。Marketers是一个已经存在的标准组。 109. You are the administrator of a SQL Server 2000 computer. Your company has client computers that are running Microsoft Windows 2000 Professional and UNIX. All client computers require access to the server. Users with domain accounts will access the server by means of the company LAN, and external users will access the server by means of the Internet. You need to configure the server so that all authorized users can connect to it. What should you do? (Each correct answer presents part of the solution. Choose all that apply.) A. Configure Windows Authentication. B. Configure Mixed Mode Authentication. C. Create a login for the Domain Users group. D. Create a login for the Guest domain user account. E. Create a login for each UNIX user, and set a password for each login. F. Create a login for each external user, and set a blank password for each login. G. Create a login named Guest, and set a blank password for the login. Answer: B C E Reason: 110. You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named CustomerInfo. This table is used to store information about your company's customers. You want some users to be allowed to modify only the table's Address column. Other users should be allowed to modify only the table's CreditCard column. Neither group of users has permission on the CustomerInfo table. You need to make sure that only authorized users make changes to the Address and CreditCard columns. What should you do? A. Create a stored procedure and require users to enter information by means of the stored procedure. B. Create a user-defined function and require users to enter information by means of the function. C. Create a rule and apply it to the Address and CreditCard columns. D. Create a constraint and apply it to the Address and CreditCard columns. Answer: A Reason: 利用传递参数的存储过程来实现对指定字段的修改。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |