Q. Which clause specifies periodic execution at fixed intervals?

View solution

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

View solution

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

View solution

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

View solution

Q. When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________

View solution

Q. When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________

View solution

Q. Triggers and events are invoked automatically by the server.

View solution

Q. A stored procedure is invoked using the statement __________

View solution

Q. What produces result sets?

View solution

Q. Which privilege is enabled to create of alter a stored function?

View solution

Q. The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.

View solution

Q. How many of the following can be used in stored procedures?

PREPARE, EXECUTE, DEALLOCATE PREPARE

View solution

Q. How many of the following can be used in stored functions?

PREPARE, EXECUTE, DEALLOCATE PREPARE

View solution