Which myisamchk variable represents the size of buffer used to hold index blocks?(a) key_buffer_size(b) read_buffer_size(c) sort_buffer_size(d) write_buffer_sizeThe question was asked during an interview.The doubt is from Checking and Repairing Database Tables in division Database Maintenance, Backups and Replication of MySQL

Which myisamchk variable represents the size of buffer used to hold in

1.	Which myisamchk variable represents the size of buffer used to hold index blocks?(a) key_buffer_size(b) read_buffer_size(c) sort_buffer_size(d) write_buffer_sizeThe question was asked during an interview.The doubt is from Checking and Repairing Database Tables in division Database Maintenance, Backups and Replication of MySQL
Answer» The CORRECT choice is (a) key_buffer_size Easy EXPLANATION: The myisamchk variable ‘key_buffer_size’ STORES the size of buffer that is used to hold index blocks. ‘read_buffer_size’ stores the size of buffer used for read operations, ‘sort_buffer_size’ is used for SORTING.

Discussion

No Comment Found

Related InterviewSolutions

Which is the stored program associated with a schedule?(a) Trigger(b) Event(c) Stored function(d) Stored procedureThe question was asked in unit test.The question is from Setting Up Replication Servers topic in division Database Maintenance, Backups and Replication of MySQL
In which directory are the DBI scripts located?(a) cgi-inc(b) cgi-bin(c) cgi-usr(d) cgi-perlThe question was posed to me in exam.Query is from Setting Up Replication Servers in portion Database Maintenance, Backups and Replication of MySQL
PHP scripts are located in the web client document tree.(a) True(b) FalseI have been asked this question during an interview.The doubt is from Setting Up Replication Servers topic in division Database Maintenance, Backups and Replication of MySQL
In which context is the privilege ‘CREATE TABLESPACE’ applied?(a) Server administration(b) Tables(c) Stored routines(d) ViewsI had been asked this question in quiz.My enquiry is from Setting Up Replication Servers topic in division Database Maintenance, Backups and Replication of MySQL
MySQL Enterprise Backup records details of each backup in _____________(a) history_backup(b) backup_history(c) backlog_history(d) history_backlogThis question was posed to me in an interview.This question is from Setting Up Replication Servers topic in chapter Database Maintenance, Backups and Replication of MySQL
Which statement suspends the replication related activity of the slave server?(a) RESUME SLAVE(b) START SLAVE(c) STOP SLAVE(d) GET SLAVEI got this question by my school teacher while I was bunking the class.My question is taken from Setting Up Replication Servers topic in section Database Maintenance, Backups and Replication of MySQL
Which statement on the master expires binary log files?(a) SHOW SLAVE STATUS(b) PURGE MASTER(c) PURGE SLAVE(d) SHOW MASTER STATUSThe question was posed to me during an internship interview.I'm obligated to ask this question of Setting Up Replication Servers in chapter Database Maintenance, Backups and Replication of MySQL
The slave stores the CHANGE MASTER parameters in the file _____________(a) slave.info(b) slave.inf(c) master.info(d) master.infI have been asked this question in an interview for internship.My question is based upon Setting Up Replication Servers topic in division Database Maintenance, Backups and Replication of MySQL
What is the default size of ‘max_binlog_cache_size’ system variable?(a) 1 GB(b) 2 GB(c) 4 GB(d) 8 GBThe question was posed to me in an online quiz.This intriguing question comes from Using Backups for Data Recovery in division Database Maintenance, Backups and Replication of MySQL
The metadata log is _______________(a) error log(b) ddl log(c) binary log(d) relay logI have been asked this question during an interview.My question is based upon Using Backups for Data Recovery topic in division Database Maintenance, Backups and Replication of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment