What is a stored procedure in a DBMS and when is it used?
- A procedure that is stored in a file system.
- A stored procedure is a precompiled collection of one or more SQL statements that can be executed as a single unit.
- A type of index in a database.
- It is a virtual table used for optimizing query performance.
Stored procedures are used to encapsulate a series of SQL statements for execution as a single unit. They enhance code modularity, security, and performance by reducing the need to send multiple queries to the database server.
Loading...
Related Quiz
- In Big Data analytics, what role does Apache Kafka serve?
- What is the main purpose of the training phase in a machine learning model?
- What is the primary function of a data warehouse in business intelligence?
- What is the primary use of the ggplot2 package in R?
- Which technique is best for dealing with outliers in a dataset?