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

问题:

[名词解释] ESS

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"] 发音部位 ()级以上地方人民政府药品监督管理部门负责行政区域内的医疗器械监督管理工作。 医疗器械产品的分类依据是()。 根据《票据法》,汇票上必须记载的事项包括()等内容。 ["确定的金额","汇票日期","付款人名称","汇票编号"] ESS
参考答案:

  参考解析

本题暂无解析

在线 客服