Question: SQL Create the following table: greate table audit emp aation varchar? (20), date asti date default sysdate) Create the following trigger: CREATE OR REPLACE TRIGGER

SQL
Create the following table: greate table audit emp aation varchar? (20), date asti date default sysdate) Create the following trigger: CREATE OR REPLACE TRIGGER audit e AFTER DELETE ON employees For EACH ROW BEGIN IE DELETING THEN INSERT INTO audis emp VALUES (USER 'DELETE' SYSDATE) END IF END: Modify the trigger and test: Perform the following: . Now modify the trigger to include an audit trail in case the employees table is changed with an UPDATE or INSERT, (Hint: you may want to use the conditional predicates INSERTING or UPDATING). Once you have made your changes test by (1) adding a new employee, (2) then make a change to the employee you added and (3) finally deleting the employee you added. . . Use a SELECT statement to display the contents of the audit emp table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
