Which three statements are true about Oracle Workflow and Oracle Alerts? (Choose three.)

Question

Options

• AAlerts can perform only one action.
• BWorkflow can support complex conditional
• CAlerts can be configured for any frequency of occurrence.
• DWorkflows can wait for a user response during an activity.
• EAlerts can perform multiple actions in a sequence that you specify.
• FAlerts run only when a database record is either updated or created

• A
  2% (1)
• B
  90% (37)
• C
  5% (2)
• F
  2% (1)

Explanation

Oracle Workflow is designed for complex business processes, so it naturally supports conditional branching (B) - routing work down different paths based on rules, attributes, or outcomes. Workflow activities can also pause and wait for a human notification response (D), such as an approval or rejection, before continuing - this is a core feature distinguishing Workflow from simple automation. Oracle Alerts, meanwhile, can be configured to execute multiple actions in a defined sequence (E), such as sending an email, running a stored procedure, and logging an entry, all from a single alert trigger.

Why the distractors are wrong:

• A is directly contradicted by E - Alerts support multiple sequential actions, not just one.
• C is misleading: Event Alerts fire only on specific database events (insert/update/delete), and Periodic Alerts run on fixed schedules - neither supports truly "any" arbitrary frequency.
• F is the classic trap: it only describes Event Alerts, ignoring Periodic Alerts, which run on a time schedule regardless of any database record change.

Memory tip: Think "W.A.I.T." - Workflow handles complex logic (B), Alerts do multiple Actions (E), and Workflow can Wait on users (D). If an answer says Alerts are limited to one action or only fire on record changes, it's ignoring half the picture.

No community discussion yet for this question.