当前位置:国家开放大学(管理信息系统)题库

问题:

[名词解释] DSS

定置管理依据安全、品质、效率、效益、和()而制定。 ["A.管理的特殊要求 ","B.造价的特殊要求 ","C.物品本身的特殊要求 ","D.气候的要求"] 群体动力 安全生产权包括()。 ["知情权","批评建议权","紧急情况处置权","要求赔偿权"] You work in a company which 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. The DB1 database contains the following stored procedure. (Line numbers are useded for reference only.)  01 CREATE PROCEDURE Sales.Procedure1  02 AS  03 IF OBJECT_ID('Service.Table') IS NOT NULL  04 DROP TABLE Service.Table;  06 CREATE TABLE Service.Table (  07 Id int PRIMARY KEY CLUSTERED,  08 Name varchar(100);  09 );  11 ...  12  GOThe following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions.  What action should you do perform?()   ["Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. ","Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. ","You should give the user the ALTER permission on the Service schema ","You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.&e"] 发音部位 DSS
参考答案:

  参考解析

本题暂无解析

在线 客服