单项选择题

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 are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you. 
So what should you do to ensure this two?()  

A.You should create a policy that targets the name of the stored procedure that is evaluated on change. 
B.You should create a policy that targets the name of the stored procedure that is evaluated on demand.
C.You should create a condition that targets the name of stored procedure that is evaluated on demand. 
D.You should create a condition that targets the name of the stored procedure that isevaluated on change. 

相关考题

You work in a company which is named Wiikigo Corp. The ...


单项选择题

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. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00. When you perform this back up, you must make sure that the overall backup will not be affected. What';s more, you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence. 
In the options below, which Transact-SQL statement should you use?()

A.BACKUP LOG DB1 TO DISK = 't:\backups\db1.trn'; 
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL; 
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH NOUNLOAD; 
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COPY_ONLY;