Multiple choice general knowledge science & technology

Which of the following operators is allowed in a trigger?

  1. CREATE INDEX

  2. RESTORE DATABASE

  3. INSERT

  4. ALTER DATABASE
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

INSERT is allowed in triggers as data modification operations. CREATE INDEX, RESTORE DATABASE, and ALTER DATABASE are DDL (Data Definition Language) operations that cannot be used within triggers. Triggers can execute INSERT, UPDATE, and DELETE operations.

Keep practicing — related questions