You need to create a trigger on the EMP table that monitors every row that is changed and places this information into the AUDIT_TABLE. What type of trigger do you create?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON EMP BEGIN INSERT INTO AUDIT_TABLE values(user ,sysdate...
- How can we create ROW level TRIGGER from following clauses used in creating trigger?
- Which of the following types of trigger is fired each time, when the table is affected by the triggering st...
- Examine this code CREATE OR REPLACE TRIGGER SECURE_emp BEFORE LOGON ON EMP BEGIN ............. END WHAT TYP...
- What does the CREATE TABLE statement do?
- A trigger can be created on which of the following objects?
- To create a trigger you need the following option
- The command to disable all the triggers on the EMP table