Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?(a) fast_queue_size(b) general_queue_size(c) slow_queue_size(d) delayed_queue_sizeI got this question in an interview.Asked question is from Tuning the Server in chapter General MySQL Administration of MySQL

Which system variable determines the number of rows from INSERT DELAYE

1.	Which system variable determines the number of rows from INSERT DELAYED statements that can be queued per table?(a) fast_queue_size(b) general_queue_size(c) slow_queue_size(d) delayed_queue_sizeI got this question in an interview.Asked question is from Tuning the Server in chapter General MySQL Administration of MySQL
Answer» RIGHT option is (d) delayed_queue_size The BEST I can explain: The system variable ‘delayed_queue_size’ determines the number of rows from INSERT DELAYED STATEMENTS that can be queued PER table (for the storage ENGINES that support DELAYED inserts).

Discussion

No Comment Found

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment