Question

You would like to have a record added to TableB every time a record is modified in TableA. What technique should you look at implementing?

A. Triggers
B. Stored procedures
C. Transactions
D. Indexes

Answer 1

To have a record added to TableB after a modification in TableA, you should use Triggers, which are automated procedures running on database actions.

Step-by-step explanation:

The technique you should look at implementing to have a record added to TableB every time a record is modified in TableA is A. Triggers. In database management, triggers are special types of stored procedures that automatically run when certain events occur in the database, such as insert, update, or delete actions on a table.

To achieve the desired functionality, you would create an AFTER UPDATE trigger on TableA that inserts a new record into TableB whenever a record in TableA gets modified. Unlike Stored Procedures or Transactions, triggers are specifically designed for reacting to data modifications, and unlike Indexes, they are not about improving query performance but are about enforcing business logic.