For sequential scans of tables we use ____________(a) read_buffer_size(b) join_buffer_size(c) read_rnd_buffer_size(d) sort_buffer_sizeThis question was addressed to me during an interview for a job.Enquiry is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML

For sequential scans of tables we use ____________(a) read_buffer_size

1.	For sequential scans of tables we use ____________(a) read_buffer_size(b) join_buffer_size(c) read_rnd_buffer_size(d) sort_buffer_sizeThis question was addressed to me during an interview for a job.Enquiry is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML
Answer» Correct option is (a) read_buffer_size For explanation I would say: For PERFORMING SEQUENTIAL SCANS of tables we USED read_buffer_size, when reading sorted rows we use read_rnd_buffer_size, join_buffer_size are allocated per-session thus for multiple join buffers MAY be created. For performing sort operation we use sort_buffer_size.

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

For sequential scans of tables we use ____________(a) read_buffer_size(b) join_buffer_size(c) read_rnd_buffer_size(d) sort_buffer_sizeThis question was addressed to me during an interview for a job.Enquiry is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment