Multiple choice technology databases

Which operation is allowed in a trigger

  1. (a) Create index

  2. (b) Alter database

  3. (c) Insert data

  4. (d) Restore Database
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Among the operations listed, only Insert data (C) is allowed inside a trigger. Triggers execute in response to DML operations (INSERT, UPDATE, DELETE) and can themselves perform data modifications. CREATE INDEX, ALTER DATABASE, and RESTORE DATABASE are DDL operations that are not permitted within a trigger because triggers execute as part of the DML transaction and these DDL operations would break transactional integrity or require exclusive locks.

Keep practicing — related questions