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