What should you do?

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. According to the company requirement, the names of all user-defined stored
procedures must contain the prefix usp_on all instances. Besides this, you must make sure
that stored procedures that do not contain this prefix cannot be created by you. What should
you do?

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. According to the company requirement, the names of all user-defined stored
procedures must contain the prefix usp_on all instances. Besides this, you must make sure
that stored procedures that do not contain this prefix cannot be created by you. What should
you do?

A.
A policy should be created. The policy targets the name of the stored procedure that is
evaluated on demand.

B.
A policy should be created. The policy targets the name of the stored procedure that is
evaluated on change.

C.
A condition should be created. The condition targets the name of the stored procedure
that is evaluated on change

D.
A condition should be created. The condition targets the name of stored procedure that is
evaluated on demand.



Leave a Reply 0

Your email address will not be published. Required fields are marked *