Related InterviewSolutions

• The privilege that must be given to the database to create a stored function or procedure is ____________(a) CREATE ROUTINE(b) CREATE METHOD(c) CREATE FUNCTION(d) CREATE PROCEDUREI had been asked this question by my college professor while I was bunking the class.Enquiry is from Updating MySQL in section General MySQL Administration of MySQL
• How would a stored function named PI() written in the database ‘sampdb’ be called?(a) PI()(b) sampdb.PI()(c) MySQL.PI()(d) db.PI()I got this question in quiz.I'd like to ask this question from Updating MySQL in section General MySQL Administration of MySQL
• The number of values returned from a stored procedure can be _______________(a) 0(b) 1(c) 2(d) 3The question was posed to me during an internship interview.Enquiry is from Updating MySQL topic in portion General MySQL Administration of MySQL
• The mode used to turn on strict mode and all of the additional restrictions is _____________(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) TRADITIONAL(d) ERROR_WHEN_DIVIDE_BY_ZEROThe question was asked in an interview for internship.This interesting question is from Updating MySQL topic in chapter General MySQL Administration of MySQL
• What is the SQL mode to check for divide by zero error?(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) ERROR_DIVIDE_BY_ZERO(d) ERROR_WHEN_DIVIDE_BY_ZEROThe question was asked by my school teacher while I was bunking the class.Asked question is from Updating MySQL in chapter General MySQL Administration of MySQL
• What is the SQL mode to check for divide by zero error?(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) ERROR_DIVIDE_BY_ZERO(d) ERROR_WHEN_DIVIDE_BY_ZEROI had been asked this question in an interview.The above asked question is from Updating MySQL in portion General MySQL Administration of MySQL
• The command to see the warning messages is ______________(a) DISPLAY WARNINGS(b) DISP WARNINGS(c) DISP WARNING(d) SHOW WARNINGSThe question was posed to me at a job interview.My query is from Updating MySQL in section General MySQL Administration of MySQL
• A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.(a) True(b) FalseThe question was posed to me in an online quiz.This key question is from Updating MySQL in division General MySQL Administration of MySQL
• Slow shutdown can be performed by setting innodb_fast_shutdown to _____________(a) 0(b) -1(c) 1(d) 2This question was posed to me in an interview for internship.The doubt is from Updating MySQL in portion General MySQL Administration of MySQL
• Which upgrade involves shutting down the old MySQL version and replacing the old binaries?(a) inplace(b) logical(c) illogical(d) systemThe question was asked in a job interview.This key question is from Updating MySQL in chapter General MySQL Administration of MySQL