Multiple choice technology

How is a trigger created or replaced if it already exist?

  1. DROP OR REPLACE ‘trigger_name’;

  2. CREATE OR RENAME TRIGGER ‘trigger_name’;

  3. CREATE OR REPLACE TRIGGER ‘trigger_name’;

  4. CREATE OR RECREATE TRIGGER ‘trigger_name’;
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SQL syntax for creating a new trigger or replacing an existing one is CREATE OR REPLACE TRIGGER followed by the trigger name. This allows modifying a trigger without first dropping it.

Keep practicing — related questions