A trigger has three parts. The ______ describes the change that activates the…

2020

A trigger has three parts.
The ______ describes the change that activates the trigger.
The ______ is a query that is run whenever the trigger is activated.
The ______ is the procedure that is executed if the trigger is activated and the condition is true.

  1. A.

    event, condition, actor

  2. B.

    entity, condition, action

  3. C.

    event, question, action

  4. D.

    event, condition, action

Attempted by 13 students.

Show answer & explanation

Correct answer: D

A trigger follows the Event-Condition-Action framework:

  1. Event: The change (like INSERT or UPDATE) that triggers the process.

  2. Condition: A test or query to check if the action should proceed.

  3. Action: The actual procedure executed. The correct option is D.

Explore the full course: Niacl Ao It Specialist