Multiple choice technology databases

Under which two circumstances do you design database triggers? (Choose two)

  1. To duplicate the functionality of other triggers.

  2. To replicate built-in constraints in the Oracle server such as primary key and foreign key.

  3. To guarantee that when a specific operation is performed, related actions are performed.

  4. For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Database triggers are designed for centralized operations and ensuring related actions occur. They should not duplicate built-in constraints or other triggers. Option C describes enforcing related actions (e.g., audit logging on update). Option D describes global operations firing regardless of user.

Keep practicing — related questions