Question
a.
True
b.
False
c.
May be True or False
d.
Can't say
Posted under MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Stored routines refers to stored functions and procedures.
Similar Questions
Discover Related MCQs
Q. Stored programs refer to stored objects of how many of the following types?
functions, procedures, triggers, events
View solution
Q. Which of the following statements does not modify the table?
View solution
Q. To produce a stored function, which statement is used?
View solution
Q. How many values can be returned from a given stored function?
View solution
Q. How many values can be returned from a stored procedure?
View solution
Q. Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?
View solution
Q. Which privilege must be given to the database to create a stored function or procedure?
View solution
Q. Which variable is set to zero when automatic privilege granting is not needed?
View solution
Q. Which procedure parameter enables the caller to pass in a value and get back a value?
View solution
Q. The IN, OUT and INOUT keywords do not apply to stored functions.
View solution
Q. For the same input parameters, if the stored function returns the same result, it is called _____________
View solution
Q. Triggers enable to enforce data integrity constraints.
View solution
Q. Which statement is used to create a trigger?
View solution
Q. For which of the following are triggers not supported?
View solution
Q. Which statement is used to remove a trigger?
View solution
Q. Before MySQL 5.1.6 which privilege was required to create and drop triggers?
View solution
Q. The TRIGGER privilege is used for the table to be able to create and drop triggers for it.
View solution
Q. Which of these is a stored program associated with a schedule?
View solution
Q. The event scheduler does not run by default.
View solution
Q. Which of the following lines is used to turn on the event scheduler?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!