Basic Networking Concepts Question:

Download Job Interview Questions and Answers PDF

What are Stored procedures?

Basic Networking Interview Question
Basic Networking Interview Question

Answer:

A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection of stored SQL statements. The results is a reduction of network traffic and better performance.

Download Basic Networking Interview Questions And Answers PDF

Previous QuestionNext Question
What is ACID property?What is wide-mouth frog?