What is a stored procedure?

A. It is a computer program stored within a database that runs to keep the database consistent when certain conditions arise.

B. It is an area of memory that is used for dynamic memory allocation.

C. It is a computer program stored in a database that is used to enforce business rules.

D. It is a software program that houses and serves business logic for use by multiple applications.

Question

Josephine Bentley

Computers & Technology

26 July, 09:42

What is a stored procedure?

A. It is a computer program stored within a database that runs to keep the database consistent when certain conditions arise.

B. It is an area of memory that is used for dynamic memory allocation.

C. It is a computer program stored in a database that is used to enforce business rules.

D. It is a software program that houses and serves business logic for use by multiple applications.

+3

Answers (1)

Know the Answer?

Jaidyn Taylor · Answer 1

The right answer is Letter B. It is an area of memory that is used for dynamic memory allocation.

Explanation:

Because a store procedure is not a computer program, neither a computer software. It is a type of code or subroutine available to applications that access a relational database management system. Such procedures are stored in the database data dictionary. It serves to save time and memory, extensive or complex processing that requires execution of several SQL.