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.