Language: PL/SQL, Oracle SQL

a) Create a table, named audit, for storing an audit trail record. It should include one column of any varchar length. b) Create four types of triggers before_table, after_table, before_row, and after_row (and named as such, i.e.., before_table, after_table, before_row, and after_row) with the event defined on update of the age column of the table Dependant and the action specified as writing an audit record into the table created in step 1. Make each audit record as Before_table trigger fired., After_table trigger fired., Before_row trigger fired., and After_row trigger fired. c) Fire the triggers created in the step ii by executing an SQL update statement for raising the ages of all dependants by 1 year. This single statement fires all four triggers.