What is the outcome of the CREATE TRIGGER statement?

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?

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?

A.
The trigger will be created successfully.

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

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

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *