Multiple choice technology databases

The ALTER TRIGGER command can be used to change the definition of an existing trigger.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle PL/SQL and most major RDBMS systems, there is no ALTER TRIGGER command. To modify a trigger, you must DROP it and then CREATE it again with the new definition. This is a two-step process.