How should you enable query plan caching?

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
To access data from PassGuideDB Entity SQL is used.
How should you enable query plan caching? Select two.

There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp uses this service to connect to a MS SQL Server 2008 database
PassGuideDB.
To access data from PassGuideDB Entity SQL is used.
How should you enable query plan caching? Select two.

A.
Use a stored procedure…

B.
Use object…

C.
Use function…

D.
Use operator…

E.
EntityConnection

F.
queryPlanCaching

G.
EntityCommand

H.
EntityCaching

I.
EntityDataReader

J.
sp_caching
K.
EnableCaching
L
caching
M.
EntityTransaction

Explanation:



Leave a Reply 1

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