Multiple choice technology databases

Table t and trigger trig are created as follows: create table t (a int) go create trigger trig on t for insert, update, delete as begin if @@rowcount > 1 rollback trigger end go The following transaction is now executed: begin tran insert t values (1) insert t values (2) insert t select * from t insert t values (3) commit go After completing this transaction, how many rows will table t contain?

  1. 0

  2. 1

  3. 2

  4. 3
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The trigger rolls back when @@rowcount > 1, preventing multi-row inserts. The first two single-row inserts (1, 2) succeed. The multi-row insert 'insert t select * from t' tries to insert 2 rows, causing rollback. The final insert (3) succeeds. Result: rows 1, 2, 3.

Keep practicing — related questions