Which command controls the maximum number of tables that the cache can hold?(a) table_open_cache(b) table_definition_cache(c) open_files_limit(d) read_buffer_sizeI have been asked this question in a national level competition.The question is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML

Which command controls the maximum number of tables that the cache can

1.	Which command controls the maximum number of tables that the cache can hold?(a) table_open_cache(b) table_definition_cache(c) open_files_limit(d) read_buffer_sizeI have been asked this question in a national level competition.The question is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML
Answer» Right answer is (a) table_open_cache Easy EXPLANATION: The option for table cache is table_open_cache. It CONTROLS the maximum NUMBER of tables that the cache can hold, we set the VARIABLE equal to the total number of table, table_definition_cache is the lightweight PARTNER to table cache.

Discussion

No Comment Found

Related InterviewSolutions

Which of the following locking method does not supported by APC?(a) File locks(b) Spin locks(c) Dead locks(d) IPC semaphoresI have been asked this question in final exam.My question is from Web Performance Optimization topic in chapter HTML Images & Web Page Files of HTML
What is hotlink protection?(a) stopping other sites from displaying images(b) stopping other sites from displaying videos(c) stopping access of source code(d) compresses an imageI have been asked this question in semester exam.My question is based upon Web Performance Optimization in chapter HTML Images & Web Page Files of HTML
Which error is invoked when SQLTransactionCallback does not execute?(a) INVALID_ACCESS_ERR(b) UNKNOWN_ERR(c) TIMEOUT_ERR(d) INVALID_STATE_ERRThis question was addressed to me in an interview for job.The query is from Web Databases in division HTML Images & Web Page Files of HTML
transaction() does not take the argument _______(a) callback(b) success callback(c) error callback(d) database nameThis question was addressed to me by my school teacher while I was bunking the class.Enquiry is from Web Databases in division HTML Images & Web Page Files of HTML
Which method is used to verifythe version number?(a) changeVersion()(b) readTransaction()(c) transaction()(d) executeSql()The question was asked by my college director while I was bunking the class.My doubt stems from Web Databases in chapter HTML Images & Web Page Files of HTML
For caption of the image we use ____________(a) (b) (c) (d) I had been asked this question in an international level competition.This intriguing question originated from Optimization of Images topic in chapter HTML Images & Web Page Files of HTML
Which of the following is used to determine browser support?(a) Modernizr.addTest(b) Modernizr.hasEvent(c) Modernizr.atRule(d) Modernizr.prefixedThis question was posed to me in a national level competition.This question is from Adding HTML features safely with Modernizr in chapter HTML Images & Web Page Files of HTML
Which of the following detects support for basic Worker API?(a) web workers(b) shared workers(c) data workers(d) blob workersI got this question during an interview.This intriguing question comes from Adding HTML features safely with Modernizr in section HTML Images & Web Page Files of HTML
404 HTTP error is generated due to ____________(a) missing JavaScript file(b) any missing file(c) slow loading of the web page(d) on removing the newline characterThis question was posed to me in class test.My question comes from Web Performance Optimization topic in portion HTML Images & Web Page Files of HTML
Modernizr.csstransformss detects _________(a) CSS 2D transforms(b) CSS 3D transforms(c) Input Types(d) Input AttributesThe question was asked in an international level competition.Asked question is from Adding HTML features safely with Modernizr in division HTML Images & Web Page Files of HTML

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment