Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?(a) PI()(b) sampdb.PI()(c) MySQL.PI()(d) db.PI()I have been asked this question during a job interview.This interesting question is from Stored Functions and Procedures topic in section Stored Programs of MySQL

Suppose a stored function named PI() is written in the database ‘sam

1.	Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?(a) PI()(b) sampdb.PI()(c) MySQL.PI()(d) db.PI()I have been asked this question during a job interview.This interesting question is from Stored Functions and Procedures topic in section Stored Programs of MySQL
Answer» Right OPTION is (b) sampdb.PI() The BEST I can explain: When a stored FUNCTION is DEFINED with the same name as a built in function, the function name should be qualified with the database name when it is invoked. The function ‘PI()’ is built in.

Discussion

No Comment Found

Related InterviewSolutions

The locking statements LOCK TABLES and UNLOCK TABLES are not permitted in stored routines.(a) True(b) FalseThe question was posed to me in a national level competition.My question is based upon Security for Stored Programs and Views in section Stored Programs of MySQL
Which privilege is enabled to create of alter a stored function?(a) SUPER(b) PRIOR(c) TOP(d) SUPERIORI got this question in a job interview.My question is based upon Security for Stored Programs and Views topic in division Stored Programs of MySQL
What produces result sets?(a) View(b) SELECT(c) Stored function(d) TriggerThe question was posed to me by my school teacher while I was bunking the class.I'm obligated to ask this question of Security for Stored Programs and Views in portion Stored Programs of MySQL
A stored procedure is invoked using the statement __________(a) INVOKE(b) SEE(c) CALL(d) RETURNI had been asked this question in semester exam.I'm obligated to ask this question of Security for Stored Programs and Views topic in section Stored Programs of MySQL
Triggers and events are invoked automatically by the server.(a) True(b) FalseThis question was posed to me in final exam.My question is taken from Security for Stored Programs and Views topic in chapter Stored Programs of MySQL
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 __________(a) good(b) bad(c) illegal(d) fareThe question was asked in an internship interview.Asked question is from Security for Stored Programs and Views in division Stored Programs of MySQL
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________(a) good(b) bad(c) illegal(d) fareI have been asked this question during an interview.Query is from Security for Stored Programs and Views in division Stored Programs of MySQL
The creation of a stored program is similar to the definition of a _______________(a) Trigger(b) Event(c) View(d) TableThe question was asked in an interview.I need to ask this question from Security for Stored Programs and Views in chapter Stored Programs of MySQL
The default definer of an event is the user who _______________(a) created the database(b) created the event(c) created the table(d) created the columnI have been asked this question by my college director while I was bunking the class.Asked question is from Events in portion Stored Programs of MySQL
To create or drop events for a database, which privilege should be granted?(a) CREATE(b) DROP(c) PRIVILEGE(d) EVENTI had been asked this question in final exam.Query is from Events in division Stored Programs of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment