Select the VALID trigger type(s)?

  1. AFTER statement trigger

  2. INSERT row trigger

  3. DELETE row trigger

  4. All of the above


Correct Option: A

AI Explanation

To answer this question, you need to understand the different types of triggers in a database.

Option A) AFTER statement trigger - This option is valid because an AFTER statement trigger is a type of trigger that is fired after a SQL statement is executed.

Option B) INSERT row trigger - This option is not valid because there is no specific trigger type called "INSERT row trigger." However, there is a trigger type called "AFTER INSERT trigger," which is fired after a new row is inserted into a table.

Option C) DELETE row trigger - This option is not valid because there is no specific trigger type called "DELETE row trigger." However, there is a trigger type called "AFTER DELETE trigger," which is fired after a row is deleted from a table.

Option D) All of the above - This option is not valid because only option A (AFTER statement trigger) is a valid trigger type.

Therefore, the correct answer is option A.

Find more quizzes: