Topic 5

Question 1

It is a prepared SQL code that you can save, so the code can be reused over and over again.

Answer 1

Stored Procedure

Question 2

Advantages of using Stored Procedure(4):

Answer 2

1. Better Performance
2. Higher Productivity
3. Ease to Use
4. Scalability

Question 3

Disadvantages of using Stored Procedure(5):

Answer 3

1. Testing
2. Debugging
3. Versioning
4. Cost
5. Portability