Multiple choice technology databases

Which of the following is true concerning triggers?

  1. You do not create them with SQL.

  2. They execute against only some applications that access a database.

  3. They have an event, condition, and action.

  4. They cannot cascade (cause another trigger to fire).
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Triggers are defined by an event (like INSERT), an optional condition (WHEN), and an action (procedural statement). They are created using SQL, execute for all applications connecting to the database, and can cascade by triggering other events, making other options incorrect.

Keep practicing — related questions