Question

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

(d) None of the mentioned

I have been asked this question in quiz.

My enquiry is from Estimating Statistics of Expression Results in portion Query Processing Techniques of Database Management

Answer 1

The correct option is (c) The execution plan is stored in the cache after it was executed the first time

Easiest explanation - A relational database table is often described as “normalized” if it is in the Third Normal Form because most of the 3NF tables are free of insertion, update, and deletion anomalies.