Q. The creation of a stored program is similar to the definition of a _______________

View solution

Q. The default definer of an event is the user who _______________

View solution

Q. To create or drop events for a database, which privilege should be granted?

View solution

Q. Which clause specifies periodic execution at fixed intervals?

View solution

Q. Which log does the event scheduler log to?

View solution

Q. If the scheduler is stopped, no events run.

View solution

Q. Which value of event_scheduler enables checking status but not changing it at runtime?

View solution

Q. Which statement is used to check the status of the event scheduler at runtime?

View solution

Q. Which of the following lines is used to turn on the event scheduler?

View solution

Q. The event scheduler does not run by default.

View solution

Q. Which of these is a stored program associated with a schedule?

View solution

Q. The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

View solution

Q. Before MySQL 5.1.6 which privilege was required to create and drop triggers?

View solution

Q. Which statement is used to remove a trigger?

View solution

Q. For which of the following are triggers not supported?

View solution

Q. Which statement is used to create a trigger?

View solution

Q. Triggers enable to enforce data integrity constraints.

View solution

Q. For the same input parameters, if the stored function returns the same result, it is called _____________

View solution

Q. The IN, OUT and INOUT keywords do not apply to stored functions.

View solution

Q. Which procedure parameter enables the caller to pass in a value and get back a value?

View solution