Multiple choice technology databases

Which of the following are true about triggers? (Choose 2)

  1. the inserted and deleted tables are created manually

  2. triggers can be disabled using alter table

  3. a single trigger can be created for both insert and delete

  4. @@sqlstatus contains the number of rows affected
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Triggers in ASE can be disabled using ALTER TABLE, and a single trigger can handle multiple DML operations (INSERT, UPDATE, DELETE) as shown in the CREATE TRIGGER syntax. The inserted and deleted tables are system-created temporary tables, not manually created. @@sqlstatus contains error codes, not row counts (that's @@rowcount).

Keep practicing — related questions