How inserting data through stored procedure do reduces network traffic and increase database performance?

A. Stored procedure can accept parameter
B. Permission check is not required
C. The execution plan is stored in the cache after it was executed the first time.
Ans: C

Posted in: sql server 2008 mcqs