The privilege that must be given to the database to create a stored fu – McqOptions

MCQOPTIONS

1.	The privilege that must be given to the database to create a stored function or procedure is ____________.
A.	CREATE PROCEDURE
B.	CREATE METHOD
C.	CREATE ROUTINE
D.	CREATE FUNCTION
E.	None of these
Answer» D. CREATE FUNCTION

Discussion

No Comment Found

Related MCQs

Identify the table name in the following statement.INSERT INTO Employee VALUES('Ajit','M',NULL);
x in the following statement is ____________.DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;
In the following code, InnoDB is __________.CREATE TABLE Employee( Emp_name CHAR(30), Emp_id INT(10), PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;
What column names are displayed when this command is executed?SHOW COLUMNS FROM Table_Name LIKE '%name';
abc in the following statement is ___________.DELETE FROM xyz WHERE abc = 5;
The collations this statement lists are ______________.SHOW COLLATION LIKE 'utf8%'
What is tamp in the following command?mysql -h xyz.host.try.net -p -u tamp
What is the host name in the following command?mysql -h interview.mania.com -p -u sampadam
The number of attributes in the following table is ______________.CREATE TABLE Student( name CHAR(30), id INT(11) );
What does Student & name specify?CREATE TABLE Student (name);