MySQL

Question: There was no supported command or GUI application available for modifying an existing trigger. Therefor, perhaps the easiest strategy for modifying a trigger is to delete and subsequently re-create it.
A
True

B
False

Note: Not available
1. Report
Question: Which is the correct syntax of displaying MySQL triggers vertically?
A
shell>show triggers \G

B
mysql>desc triggers \G

C
mysql>show triggers \G

D
mysql>show trigger \G

E
mysql>show triggers \G;

Note: Not available
1. Report
Question: MySQL triggers are two kinds: before triggers and after triggers.
A
False

B
True

Note: Not available
1. Report
Question: Triggers cannot be applied on SQL statement
A
SELECT

B
DELETE

C
INSERT

D
UPDATE

Note: Not available
1. Report
Question: Which of the following trigger prefix are used in the trigger statement body for table column for reading new or old row data?
A
INI

B
OLD

C
SET

D
NEW

Note: Not available
1. Report

Question: There was no supported command or GUI application available for modifying an existing trigger. Therefor, perhaps the easiest strategy for modifying a trigger is to delete and subsequently re-create it.