Question

Which of the following can be automatically executed by the database?

a) Function
b) Trigger
c) View
d) Procedure

Answer 1

Triggers can be automatically executed by the database, while functions, procedures, and views are not.

Step-by-step explanation:

Triggers can be automatically executed by the database. A trigger is a stored program that is executed when a specific event occurs, such as an INSERT, UPDATE, or DELETE operation on a table. Triggers are used to enforce data integrity rules or to perform tasks related to data changes.

Functions and Procedures are not automatically executed by the database. They are stored programs that can be called by other programs or by users. Functions return a value, while procedures do not return a value.

A View is not executed by the database, but it is a saved SQL query that can be treated as a table. When a user queries a view, the underlying SQL query is executed to retrieve the data.