To use ‘mysqldbcopy’ which privileges are required on the source server?(a) CREATE(b) INSERT(c) UPDATE(d) SELECTI had been asked this question in an interview.My query is from Copying Databases to Another Server in chapter Database Maintenance, Backups and Replication of MySQL

To use ‘mysqldbcopy’ which privileges are required on the source s

1.	To use ‘mysqldbcopy’ which privileges are required on the source server?(a) CREATE(b) INSERT(c) UPDATE(d) SELECTI had been asked this question in an interview.My query is from Copying Databases to Another Server in chapter Database Maintenance, Backups and Replication of MySQL
Answer» Right choice is (d) SELECT The best explanation: To use the UTILITY program ‘mysqldbcopy’, the USER MUST have SELECT privileges for the DATABASE(s) on the source server and have CREATE, INSERT, UPDATE on the DESTINATION server.

Discussion

No Comment Found

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

To use ‘mysqldbcopy’ which privileges are required on the source server?(a) CREATE(b) INSERT(c) UPDATE(d) SELECTI had been asked this question in an interview.My query is from Copying Databases to Another Server in chapter Database Maintenance, Backups and Replication of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment