The system variable controls the size of the table cache _________________(a) table_cache(b) cache_table(c) open_cache(d) cache_openThis question was posed to me in an internship interview.My question comes from General MySQL Administration topic in section MySQL Administration of MySQL

The system variable controls the size of the table cache _____________

1.	The system variable controls the size of the table cache _________________(a) table_cache(b) cache_table(c) open_cache(d) cache_openThis question was posed to me in an internship interview.My question comes from General MySQL Administration topic in section MySQL Administration of MySQL
Answer» The CORRECT choice is (a) table_cache The explanation is: In MYSQL, when the server OPENS table files it keeps them open to minimize the number of file-opening operations. It maintains INFORMATION about open files in the table CACHE.

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

The system variable controls the size of the table cache _________________(a) table_cache(b) cache_table(c) open_cache(d) cache_openThis question was posed to me in an internship interview.My question comes from General MySQL Administration topic in section MySQL Administration of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment