The statement ____ recompiles the trigger named sales_trg.
A) ENABLE TRIGGER sales_trg COMPILE;
B) DROP TRIGGER sales_trg COMPILE;
C) COMPILE TRIGGER sales_trg COMPILE;
D) ALTER TRIGGER sales_trg COMPILE;

Question

Quizplus · Accepted Answer

The correct syntax to recompile an existing trigger is ALTER TRIGGER <trigger_name> COMPILE. In this case, the trigger name is sales_trg, so the correct statement is ALTER TRIGGER sales_trg COMPILE. Option A is incorrect because ENABLE TRIGGER is used to enable or disable a trigger, not to recompile it. Option B is incorrect because DROP TRIGGER is used to delete a trigger, not to recompile it. Option C is invalid syntax as COMPILE is already included in the ALTER TRIGGER statement.

The Statement ____ Recompiles the Trigger Named Sales_trg