gs gs113 Stored Programs - Triggers - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Stored Programs. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: Which statement is used to create a trigger?
CREATE TRIGGER
CREATE TRIGGERS
PRODUCE TRIGGER
PRODUCE TRIGGERS
Question 3: For which of the following are triggers not supported?
delete
update
insert
views
Question 4: Which statement is used to remove a trigger?
REMOVE
DELETE
DROP
CLEAR
Question 5: Before MySQL 5.1.6 which privilege was required to create and drop triggers?
PRIVILEGE
TRIGGER
SUPER
MACRO
Question 7: What is abc in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
trigger name
table name
trigger statement
update statement
Question 8: What is def in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
trigger name
table name
trigger statement
update statement
Question 9: What is ghi in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
trigger name
table name
trigger statement
update statement
Question 10: What is def in the following MySQL statement?
DECLARE abc HANDLER FOR def ghi;
action
condition value
statement
null
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
