当前位置:MCTS(70-432)题库

问题:

[单选] You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?()  

A . You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. 
B . You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. 
C . You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header 
D . You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

Which directive defines master page-precise attributes that are used by the ASP.NET page parser and compiler? () @ MasterType。 @ Master。 @ PageType。 @ MasterPage。 抗日战争时期,毛泽东提出的统一战线的根本策略原则是()。 又联合又斗争。 不要四面出击。 加强团结。 加强斗争。 Your company has a server named SRV1 that runs windows server 2008. The default print server role is installed on SRV1 the company wants to centralize printing on SRV1 for both UNIX and windows users. You need to provide support to the UNIX users who print on SRV1. What are two possible ways to achieve this goal? () Install the internet printing server role on SRV1.。 Install the line printer daemon (LPD) services role service on SRV1.。 Configure the printers on SRV1 to use line printer remote printing.。 Install the file server role on SRV1 and activate the services for the NFS Role service option.。 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO\Supervisors. A Windows user named User1 is a member of the WIIKIGO\Supervisors group. WIIKIGO\Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?()    DROP LOGIN "WIIKIGO\User1"; 。  EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';。  EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1'; 。  CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1"。 感觉的特性事故致因理论认为安全工作应以()为主。 You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?()  
参考答案:

  参考解析

本题暂无解析

在线 客服