Multiple choice technology databases

In Oracle 9i, we can specify the FIRING order in which the that are created on a table

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle 9i, you cannot specify the firing order of triggers on a table. Triggers fire in an undefined order unless you use a single trigger with ordered logic. Oracle 10g introduced the FOLLOWS clause to control trigger execution order.

AI explanation

In Oracle 9i, when multiple triggers of the same type (e.g., several BEFORE INSERT triggers) are defined on the same table, Oracle does not guarantee or let you specify their firing order — the order among same-type triggers is undefined/implementation-dependent in that era of Oracle (ordering control via FOLLOWS/PRECEDES wasn't introduced until much later, in 11g). So the statement is False, correctly marked. True would incorrectly imply Oracle 9i offered explicit firing-order control, which it did not.

Keep practicing — related questions