Which character does the mysql client program recognize as a statement delimiter?(a) :(b) .(c) ;(d) ,I have been asked this question in an interview for job.The origin of the question is Compound Statements and Statement Delimiters topic in chapter Stored Programs of MySQL

Which character does the mysql client program recognize as a statement

1.	Which character does the mysql client program recognize as a statement delimiter?(a) :(b) .(c) ;(d) ,I have been asked this question in an interview for job.The origin of the question is Compound Statements and Statement Delimiters topic in chapter Stored Programs of MySQL
Answer» Right option is (c) ; For explanation I WOULD SAY: By default, MYSQL itself recognizes the semicolon as a statement delimiter, so the delimiter must be redefined temporarily to CAUSE mysql to pass the ENTIRE stored program definition to the server.

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

Which character does the mysql client program recognize as a statement delimiter?(a) :(b) .(c) ;(d) ,I have been asked this question in an interview for job.The origin of the question is Compound Statements and Statement Delimiters topic in chapter Stored Programs of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment