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

问题:

[单选]

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?()  

A . Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause. 
B . Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement. 
C . You should give the user the ALTER permission on the Service schema 
D . You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.&e

安全生产权包括()。 知情权。 批评建议权。 紧急情况处置权。 要求赔偿权。 简述碱石灰烧结法生产氧化铝的基本原理。 DSS ()级以上地方人民政府药品监督管理部门负责行政区域内的医疗器械监督管理工作。 胴体重

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?()  

参考答案:

  参考解析

本题暂无解析

在线 客服