Select the VALID trigger type(s)?

  1. AFTER statement trigger

  2. INSERT row trigger

  3. DELETE row trigger

  4. UPDATE row trigger


Correct Option: A

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) AFTER statement trigger - This option is correct. AFTER statement triggers are valid trigger types in database systems. They are executed after a SQL statement is executed.

Option B) INSERT row trigger - This option is incorrect. INSERT row triggers are not valid trigger types. Instead, you can use an AFTER INSERT trigger or a BEFORE INSERT trigger.

Option C) DELETE row trigger - This option is incorrect. DELETE row triggers are not valid trigger types. Instead, you can use an AFTER DELETE trigger or a BEFORE DELETE trigger.

Option D) UPDATE row trigger - This option is incorrect. UPDATE row triggers are not valid trigger types. Instead, you can use an AFTER UPDATE trigger or a BEFORE UPDATE trigger.

The correct answer is A) AFTER statement trigger. This option is correct because AFTER statement triggers are valid trigger types in database systems. They are executed after a SQL statement is executed.

Find more quizzes: