For which table does ‘REPAIR TABLE’ not work?(a) MyISAM(b) ARCHIVE(c) CSV(d) InnoDBThis question was addressed to me in an online quiz.This intriguing question originated from Performing Database Maintenance with the Server Running topic in portion Database Maintenance, Backups and Replication of MySQL

For which table does ‘REPAIR TABLE’ not work?(a) MyISAM(b) ARCHIVE

1.	For which table does ‘REPAIR TABLE’ not work?(a) MyISAM(b) ARCHIVE(c) CSV(d) InnoDBThis question was addressed to me in an online quiz.This intriguing question originated from Performing Database Maintenance with the Server Running topic in portion Database Maintenance, Backups and Replication of MySQL
Answer» The correct option is (d) InnoDB The EXPLANATION: ‘REPAIR TABLE’ works for MyISAM, ARCHIVE, and CSV tables. For MyISAM tables, it has the same EFFECT as ‘myisamchk –recover’ tbl_name by default. This statement does not work with views.

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