Oracle
1Z0-147 · Question #40
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 5:00pm. Which types of trigger do you create? (Choose…
The correct answer is B. B. row level BEFORE INSERT OR UPDATE OR DELETE ON EMP D. D. statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP. See the full explanation below for the reasoning.
Question
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 5:00pm. Which types of trigger do you create? (Choose two.)
Options
- AA. row level AFTER INSERT OR UPDATE OR DELETE ON EMP
- BB. row level BEFORE INSERT OR UPDATE OR DELETE ON EMP
- CC. statement level AFTER INSERT OR UPDATE OR DELETE ON EMP
- DD. statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP
How the community answered
(39 responses)- A13% (5)
- B79% (31)
- C8% (3)
Community Discussion
No community discussion yet for this question.