1) Row level trigger - An event is triggered for each row upated, inserted or deleted.
2) Statement level trigger - An event is triggered for each sql statement executed.
Does it mean delete all employees that are in department LCR?
Does it mean set to null the dept_code for employees in department LCR?
4) Finally the AFTER statement level trigger fires.
2) Next BEFORE row level trigger fires, once for each row affected.Notes on Updatable Views An updatable view is one you can use to insert, update, or delete base table rows.You can create a view to be inherently updatable, or you can create an INSTEAD OF trigger on any view to make it updatable.To learn whether and in what ways the columns of an inherently updatable view can be modified, query the USER_UPDATABLE_COLUMNS data dictionary view.The information displayed by this view is meaningful only for inherently updatable views.