COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CREATE TRIGGER SumTotal AFTER CREATE ON
|
|
|
CREATE TRIGGER SumTotal AFTER DROP ON
|
|
|
CREATE TRIGGER SumTotal AFTER DELETE ON
|
|
|
CREATE TRIGGER SumTotal AFTER SELECT ON
|
Detailed explanation-1: -MySQL AFTER DELETE triggers are automatically invoked after a delete event occurs on the table. In this syntax: First, specify the name of the trigger that you want to create in the CREATE TRIGGER clause. Second, use AFTER DELETE clause to specify the time to invoke the trigger.
Detailed explanation-2: -Use the DROP TRIGGER command to drop an existing trigger.
Detailed explanation-3: -Detailed Solution. The correct answer is Drop. DROP-It is a Data Definition Language(DDL) Command which is used to delete, tables, views, triggers, etc from a database. A DROP statement in SQL removes a component from a relational database management system (RDBMS).
Detailed explanation-4: -Trigger After Delete Salesforce executes the custom logic after the data is deleted from the Salesforce Database. If you are looking to delete related records, you can make use of Trigger After Delete Salesforce.