Which types of stored procedures should you alter?

You need to alter stored procedures to use the WITH RECOMPILE option. Which types of stored
procedures should you alter? (Each correct answer represents a complete solution. Choose two.)

You need to alter stored procedures to use the WITH RECOMPILE option. Which types of stored
procedures should you alter? (Each correct answer represents a complete solution. Choose two.)

A.
Stored procedures implemented from CLR assemblies.

B.
Stored procedures that require the FOR REPLICATION option.

C.
Stored procedures that require the WITH ENCRYPTION option.

D.
Stored procedures that contain queries that use the OPTION (RECOMPILE) hint.



Leave a Reply 0

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