What are the advantages of using triggers over stored procedures in certain scenarios?
- All of the above
- Enhanced performance
- Improved data integrity
- Reduced application complexity
Triggers in DB2 offer improved data integrity by enforcing constraints and business rules directly at the database level. This ensures that data remains consistent and valid, regardless of how it is accessed or modified. While stored procedures can also enhance data integrity, triggers provide an additional layer of protection by automatically executing when specific events occur, without requiring explicit invocation by applications.
Loading...
Related Quiz
- What are some considerations for I/O optimization in DB2 performance tuning?
- How can you verify the successful completion of the DB2 installation process?
- Which aspect of the database does the Health Monitor primarily focus on?
- Analyzing and optimizing the ________ can lead to better overall DB2 performance.
- The AVG() function in DB2 calculates the ________ of the values in a numeric column.