How Do You Specify That a Trigger Should Only Fire

question 42

Multiple Choice

How do you specify that a trigger should only fire if the value of the column AMOUNT is less than 100?

• A)IF amount < 100
• B)WHEN amount < 100
• C)ONLY IF amount < 100
• D)ONLY WHEN amount < 100

---

Definitions:

Emergency Rooms

Hospital departments designed to provide immediate medical treatment to patients with acute illnesses or injuries.

General Integer Variables

Variables in mathematical models that can take only integer values, often used in optimization problems.

Nonsmooth Models

Mathematical or computational models characterized by abrupt changes, making them not continuously differentiable or lacking smooth gradients.

Excel Functions

Predefined formulas in Microsoft Excel that perform calculations using specific values, in a particular order, to return a result.