The server listens on a network port for TCP/IP connections unless started with the option ______________(a) –networking(b) –skip-networking(c) –skip-networks(d) –quit-networkingThe question was asked in an internship interview.The query is from Controlling How the Server Listens for Connections in portion General MySQL Administration of MySQL

The server listens on a network port for TCP/IP connections unless sta

1.	The server listens on a network port for TCP/IP connections unless started with the option ______________(a) –networking(b) –skip-networking(c) –skip-networks(d) –quit-networkingThe question was asked in an internship interview.The query is from Controlling How the Server Listens for Connections in portion General MySQL Administration of MySQL
Answer» Correct answer is (b) –skip-networking The EXPLANATION: On all the platforms the SERVER LISTENS on a network port for the TCP/IP connections, unless and until it is started with the –skip-networking option. The DEFAULT port NUMBER is 3306.

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