Interview Questions And Answers Forum

alisiddiqui

Banned

Registered: 2015-02-23

Posts: 949

Reducing Network Traffic And Increasing Database Performance:

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

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

Correct Answer is Option A):
The execution plan is stored in the cache after it was executed the first time.