What SQL feature does a DBA utilize to automatically store product rating history without manual queries?

What SQL feature does a DBA utilize to automatically store product rating history without manual queries?

• A. Stored Procedures
• B. Views
• C. Triggers
• D. Functions

Answer: (C)

The feature that a DBA would utilize to automatically store product rating history without manual queries is a trigger. Triggers are special types of stored procedures that are automatically executed or fired when specific events occur in the database, such as the insertion, update, or deletion of records in a table.

In the context of storing product rating history, a trigger can be defined to capture changes in product ratings whenever an update is made to the product ratings table. For example, if a new rating is added, a trigger can automatically create an entry in the product rating history table, capturing the details of the rating change, the timestamp, and other relevant data. This minimizes the need for manual queries or interventions by the DBA to log this information, ensuring that the history of rating changes is maintained accurately and consistently.

Stored procedures, views, and functions serve different purposes. Stored procedures are collections of SQL statements that can be executed to perform a specific task, but they would require manual invocation rather than operating automatically in response to database changes. Views are virtual tables that present data in a specific way but do not store data themselves; they simply display it based on underlying queries. Functions return a single value or a table and are primarily used to perform calculations or data transformations. Hence