The log in which data changes received from a replication master server are written are ______________(a) error log(b) general query log(c) binary log(d) relay logI got this question by my college director while I was bunking the class.My question is based upon General MySQL Administration topic in section MySQL Administration of MySQL

The log in which data changes received from a replication master serve

1.	The log in which data changes received from a replication master server are written are ______________(a) error log(b) general query log(c) binary log(d) relay logI got this question by my college director while I was bunking the class.My question is based upon General MySQL Administration topic in section MySQL Administration of MySQL
Answer» Right answer is (d) relay log The EXPLANATION is: The Relay Log has the DATA changes received from a replication master SERVER written in it. The problems encountered during the starting, running or stopping of ‘mysqld’ are written in error log.

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

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment