You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted:

@old _countryNames with the value of the Name field @old _countryName with the value of the code field You may assume that only one row is ever deleted at a time. CREATE TRIGGER Country_ad AFTER DELETE ON Country FOR EACH ROW SET @old _CountryName= NEW.Name, @ old _CountryCode=NEW.Code; What is the outcome of the CREATE TRIGGER statement?

Question

You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted:

@old _countryNames with the value of the Name field @old _countryName with the value of the code field You may assume that only one row is ever deleted at a time. CREATE TRIGGER Country_ad AFTER DELETE ON Country FOR EACH ROW SET @old _CountryName= NEW.Name, @ old _CountryCode=NEW.Code; What is the outcome of the CREATE TRIGGER statement?

Accepted Answer

B. An error results because the NEW keyword cannot be used in a DELETE trigger.

Answer

A. The trigger will be created successfully.

Answer

C. An error results because FOR EACH ROW is invalid syntax.

Answer

D. An error results because a BEGIN. . .END block is required.

You wish to create a trigger on the country table. It will populate two session variables based on the row that is deleted: @old _countryNames with the value of the Name field @old _countryName with…

Question

Options

How the community answered

Community Discussion