gs gs113 Stored Programs - Stored Functions and Procedures - 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: To produce a stored function, which statement is used?
PRODUCE FUNCTION
CREATE FUNCTION
PRODUCE PROCEDURE
CREATE PROCEDURE
Question 4: Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?
PI()
sampdb.PI()
MySQL.PI()
db.PI()
Question 5: Which privilege must be given to the database to create a stored function or procedure?
CREATE ROUTINE
CREATE METHOD
CREATE FUNCTION
CREATE PROCEDURE
Question 6: Which variable is set to zero when automatic privilege granting is not needed?
automatic_sp_privileges
automatic_ps_privileges
automatic_pg_privileges
automatic_gp_privileges
Question 9: For the same input parameters, if the stored function returns the same result, it is called _____________
deterministic
non deterministic
regular
monotonous
Question 10: What is abc 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
