Database Management Systems (DBMS)
What is Stored procedure primarily used for?
- A. A precompiled collection of SQL statements stored in a database that can be executed as a single unit. ✓
- B. A large, centralized repository of integrated data from multiple sources used for reporting and analysis.
- C. A database property ensuring that relationships between tables remain consistent, typically enforced through foreign keys.
- D. A subset of SQL primarily represented by the SELECT statement, used to retrieve data from a database.
Correct answer
A. A precompiled collection of SQL statements stored in a database that can be executed as a single unit.
Explanation
Stored procedure refers to a precompiled collection of SQL statements stored in a database that can be executed as a single unit.