Multiple choice technology databases

What is a trigger

  1. A piece of logic written in PL/SQL

  2. Executed at the arrival of a SQL*FORMS event

  3. Both A & B

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A trigger is procedural code (PL/SQL in Oracle) that automatically executes in response to certain events on a table or view. The answer captures both aspects: it's written in PL/SQL (option A) and is executed by events (option B). Triggers are used to enforce business rules, maintain data integrity, and automate database tasks.

Keep practicing — related questions