gs gs113 Stored Programs - Events - 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 1: Which of these is a stored program associated with a schedule?
Trigger
Event
Stored function
Stored procedure
Question 3: Which of the following lines is used to turn on the event scheduler?
event_scheduler = ON
eventscheduler = ON
event_scheduler_ON
events_scheduler_ON
Question 4: Which statement is used to check the status of the event scheduler at runtime?
SHOW STATUS OF ‘event_scheduler’
SHOW VARIABLES OF ‘event_scheduler’
SHOW STATUS LIKE ‘event_scheduler’
SHOW VARIABLES LIKE ‘event_scheduler’
Question 7: Which log does the event scheduler log to?
error
record
library
update
Question 8: Which clause specifies periodic execution at fixed intervals?
EVERY
ALL
AT
ALTERNATE
Question 9: To create or drop events for a database, which privilege should be granted?
CREATE
DROP
PRIVILEGE
EVENT
Question 10: The default definer of an event is the user who _______________
created the database
created the event
created the table
created the column
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
