What is used to perform an analysis of key values by the server?(a) ANALYZE KEYS(b) ANALYZE TABLE(c) PERFORM ANALYSIS(d) PERFORM TABLE ANALYSISThis question was posed to me in an online interview.Query is from MySQL Components in chapter MySQL Administration of MySQL

What is used to perform an analysis of key values by the server?(a) AN

1.	What is used to perform an analysis of key values by the server?(a) ANALYZE KEYS(b) ANALYZE TABLE(c) PERFORM ANALYSIS(d) PERFORM TABLE ANALYSISThis question was posed to me in an online interview.Query is from MySQL Components in chapter MySQL Administration of MySQL
Answer» Right option is (b) ANALYZE TABLE Explanation: In MySQL, for the MYISAM and INNODB tables, the server can be told to PERFORM an analysis of key values by ISSUING the ANALYZE TABLE STATEMENT. It helps in knowing about query optimization.

Discussion

No Comment Found

Related InterviewSolutions

What is the general statement-issuing routine?(a) mysql_real_query()(b) mysql_query_real()(c) mysql_image_query()(d) mysql_query_image()I got this question in an interview for job.This is a very interesting question from Database Maintenance, Backups and Replication in portion MySQL Administration of MySQL
The header that should be included first is ______________(a) my_global.h(b) my_sys.h(c) mysql.h(d) my_local.hI have been asked this question in an online interview.Query is from Database Maintenance, Backups and Replication topic in division MySQL Administration of MySQL
The library file that contains various portability macros and definitions is ______________(a) my_global.h(b) my_sys.h(c) mysql.h(d) my_local.hI have been asked this question during an online exam.I want to ask this question from Database Maintenance, Backups and Replication topic in division MySQL Administration of MySQL
SBR replication is ______________(a) Statement based(b) Row based(c) Column based(d) Table basedThe question was asked in an interview.My enquiry is from Database Maintenance, Backups and Replication topic in chapter MySQL Administration of MySQL
Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.(a) True(b) FalseI had been asked this question in homework.Asked question is from Database Maintenance, Backups and Replication in division MySQL Administration of MySQL
To reload a delimited text data file use ______________(a) mysqldump(b) mysqld(c) mysqlimport(d) mysqlnaiveThis question was posed to me in a job interview.The above asked question is from Database Maintenance, Backups and Replication topic in division MySQL Administration of MySQL
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________(a) –multiple-transaction(b) –single-transaction(c) –double-transaction(d) –no-transactionI have been asked this question in examination.The doubt is from Database Maintenance, Backups and Replication in chapter MySQL Administration of MySQL
What is the option for specifying the executable name while compiling with gcc?(a) -e(b) -o(c) -a(d) -bI had been asked this question during an interview for a job.Question is from Access Control and Security topic in chapter MySQL Administration of MySQL
The option necessary to compile a C program havin math functions is ______________(a) -lm(b) -ln(c) -lp(d) -lqThe question was posed to me during an online exam.Query is from Access Control and Security in division MySQL Administration of MySQL
The language in which image processing is least simple is ______________(a) PHP(b) Perl(c) Python(d) CI got this question in homework.I'm obligated to ask this question of Access Control and Security topic in division MySQL Administration of MySQL

What is used to perform an analysis of key values by the server?(a) ANALYZE KEYS(b) ANALYZE TABLE(c) PERFORM ANALYSIS(d) PERFORM TABLE ANALYSISThis question was posed to me in an online interview.Query is from MySQL Components in chapter MySQL Administration of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment