A(n)________ is a computer program stored within a database that runs to keep the database consistent when certain conditions arise.
A)stored procedure
B)index
C)trigger
D)transaction

Question

Quizplus · Accepted Answer

A trigger is a type of stored procedure that is automatically executed in response to certain database events such as inserting, updating or deleting data. It is typically used to enforce business rules or to log changes to the database. Stored procedures (A) are similar to triggers but are executed manually instead of automatically. Indexes (B) are used to optimize queries on the database. Transactions (D) are used to ensure the integrity of the database by grouping a set of database operations into a single atomic unit of work.

A(n)________ Is a Computer Program Stored Within a Database That