What performs a key distribution analysis and stores the distribution for the named table or tables?(a) ANALYZE TABLE(b) CHECK TABLE(c) CHECKSUM TABLE(d) OPTIMIZE TABLEThe question was asked in examination.I would like to ask this question from Principles of Preventive Maintenance topic in chapter Database Maintenance, Backups and Replication of MySQL

What performs a key distribution analysis and stores the distribution

1.	What performs a key distribution analysis and stores the distribution for the named table or tables?(a) ANALYZE TABLE(b) CHECK TABLE(c) CHECKSUM TABLE(d) OPTIMIZE TABLEThe question was asked in examination.I would like to ask this question from Principles of Preventive Maintenance topic in chapter Database Maintenance, Backups and Replication of MySQL
Answer» Right choice is (a) ANALYZE TABLE For explanation: ‘ANALYZE TABLE’ performs a KEY DISTRIBUTION analysis and stores the distribution for the NAMED table or tables. For the MYISAM tables, this statement is equivalent to USING ‘myisamchk –analyze’.

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