Select from following answers:- using Instead Of Triggers
- Implmenting After Triggers (For Triggers)

- Creating Stored Proceures
- Creating User Defined functions
- All Above
Trigger should be created. A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
That too "After Trigger" should be created for "Transaction table". "After trigger" run after an insert, update or delete on a table.
As soon as modifcation made in Transaction table "After trigger" fired and should insert the row in Log table.
Instead Of Triggers used as interceptor for our table.If any one tries to modify our table which has instead of triggers, then instead of triggers will be fired.
Stored procedures are pre compiled statements for performing repetitive tasks
User-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value and table format.
Show Correct Answer
Asked In: CTS Interview |
Alert Moderator