Database Management Systems (DBMS)
What is Stored procedure primarily used for?
Difficulty: Medium
- 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.
Correct answer
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Which statement correctly explains Data Query Language (DQL)?
- Select the accurate description of Composite key.
- Select the correct name for: a subset of SQL primarily represented by the SELECT statement, used to retrieve d...
- Which term refers to a database property ensuring that relationships between tables remain consistent, typical...
- In computer science, Data Manipulation Language (DML) refers to which of the following?
- What does Referential integrity refer to?