Trigger, MySQL

Question: Which is the smallest integer range?
A
INT

B
TINYINT

C
SMALLINT

D
None of them

Note: Not available
1. Report
Question: Triggers are made available since MySQL version 5.
A
True

B
False

Note: Not available
1. Report
Question: Can I call a trigger directly called from an application?
A
No

B
Yes

Note: Not available
1. Report
Question: Triggers are also referred to as database
A
function

B
event

C
procedure

D
datatype

Note: Not available
1. Report
Question: Which is not the purpose of using triggers?
A
Audit trails

B
Validation

C
Referential integrity enforcement

D
Viewing data

Note: Not available
1. Report
Question: Which of the following statement about limitations of MySQL triggers is incorrect?
A
TEMPORARY tables are not supported

B
Views are not supported

C
Result sets can't be returned from a trigger

D
Triggers must be unique

E
Error handling and reporting support is immature

F
Must use prefix (ad,ai,au,bd,bi,bu) of naming a trigger

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.
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

First Prev 1 2 Next Last

Question: Which is the smallest integer range?

Question: Triggers are made available since MySQL version 5.

Question: Can I call a trigger directly called from an application?

Question: Triggers are also referred to as database

Question: Which is not the purpose of using triggers?

Question: Which of the following statement about limitations of MySQL triggers is incorrect?

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.

Question: Which is the correct syntax of displaying MySQL triggers vertically?

Question: MySQL triggers are two kinds: before triggers and after triggers.

Question: Triggers cannot be applied on SQL statement