You need to create a trigger to ensure that information in the EMP table is only modified during business hours, Monday to Friday from 9:00am to 500pm Which types of trigger do you create? (Choose two.)
A.
row level AFTER INSERT OR UPDATE OR DELETE ON EMP
B.
row level BEFORE INSERT OR UPDATE OR DELETE ON EMP
C.
statement level AFTER INSERT OR UPDATE OR DELETE ON EMP
D.
statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP
Explanation:
B: You would want to create a trigger that fires BEFORE the DML Statement. A row level BEFORE INSERT OR UPDATE OR DELETE ON EMP trigger would satisfy the requirement.
D: A statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP trigger would satisfy the requirement.
Incorrect Answers
A & C: If you create a trigger that fires AFTER the DML statement then you would not be able to prevent the EMP table from being modified outside business hours.