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