The max_binlog_cache_size system variable has default size ______________(a) 1 GB(b) 2 GB(c) 4 GB(d) 8 GBThe question was asked in an interview.I would like to ask this question from General MySQL Administration in section MySQL Administration of MySQL

The max_binlog_cache_size system variable has default size ___________

1.	The max_binlog_cache_size system variable has default size ______________(a) 1 GB(b) 2 GB(c) 4 GB(d) 8 GBThe question was asked in an interview.I would like to ask this question from General MySQL Administration in section MySQL Administration of MySQL
Answer» The correct option is (c) 4 GB Easy explanation: The max_binlog_cache_size system variable can be USED to restrict the total size used to cache a multiple-statement transaction. If transaction is larger than this it FAILS and ROLLS BACK.

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 max_binlog_cache_size system variable has default size ______________(a) 1 GB(b) 2 GB(c) 4 GB(d) 8 GBThe question was asked in an interview.I would like to ask this question from General MySQL Administration in section MySQL Administration of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment