Which of the following is a legal command when used in a trigger body?
A)COMMIT
B)SAVEPOINT
C)SELECT
D)ROLLBACK

Name: Which of the following is a legal command when used in a trigger body? A)COMMIT B)SAVEPOINT C)SELECT D)ROLLBACK
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

Quizplus · Accepted Answer

SELECT is a legal command in a trigger body because it allows the trigger to query data from the database. COMMIT and ROLLBACK are not allowed because they would interfere with the transaction that the trigger is part of. SAVEPOINT is also not typically used within triggers.

Which of the Following Is a Legal Command When Used