Multiple choice technology databases

Which T-SQL elements can be used in a stored procedure? (Choose 2)

  1. 'return', without a return value

  2. 'rollback transaction'

  3. 'rollback trigger'

  4. the built-in function 'update()'
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

RETURN without a value is valid in stored procedures for control flow. ROLLBACK TRANSACTION can be used within procedures to manage transactions. ROLLBACK TRIGGER is only valid within triggers, not procedures. update() is a trigger-specific function unavailable in procedures.

Keep practicing — related questions