Question
Which of the following is true about triggers in a
relational database?Solution
Triggers are database objects that automatically execute predefined actions in response to specific events, such as INSERT, UPDATE, or DELETE operations. They are used to enforce complex business rules, maintain audit trails, or synchronize tables. For instance, a trigger can automatically log changes to a table in an audit table whenever a record is updated. Triggers are associated with a table or a view and fire without manual intervention, making them ideal for automation. While powerful, they should be used judiciously to avoid performance bottlenecks in high-transaction environments. Why Other Options Are Incorrect :
- Triggers can be manually executed by database administrators : Triggers are event-driven and cannot be executed manually.
- Triggers replace indexes for optimizing queries : Indexes are designed to optimize query performance, while triggers are for automating responses to events.
- Triggers are only used for logging data changes : While logging is a common use case, triggers have broader applications like enforcing business rules.
- Triggers can only be defined for INSERT operations : Triggers can be defined for INSERT, UPDATE, DELETE, or even complex conditions.
_________ is the study of internal structure of the plants.
Which one of the following lymphoid organ is large at birth but reduces with age ?Â
Which of the following organs regulates water balance and blood pressure in the body?
- A person with low levels of hemoglobin is likely to suffer from:
Flocs in sewage treatment refer to:
Amino acid is attached to which site of tRNA ?
Which of the following represents net primary productivity?
What is an excretory organ of the cockroach?
Which of the following is the smallest known flowering plant?
How many histone proteins are present in a nucleosome core?