Under which two circumstances do you design database triggers? (Choose two)
A.
To duplicate the functionality of other triggers.
B.
To replicate built-in constraints in the Oracle server such as primary key and foreign key.
C.
To guarantee that when a specific operation is performed, related actions are performed.
D.
For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.
Explanation:
C: When a specific event occurs you can specify that any related code is executed by implementing a Trigger.
D: Triggers allow you have control regardless of which user or which application made the change.
Incorrect AnswersA: You do not want to create a Trigger when a trigger already exists for the specified event.
B: You should not create a Trigger to Trigger to perform functionality that is already built into the Oracle server.