What is the purpose of changing ownership of datadir to the ‘mysql’ user?

Correct Answer for the Question – What is the purpose of changing ownership of datadir to the ‘mysql’ user? is given below What is the purpose of changing ownership of datadir to the ‘mysql’ user? MySQL needs to be run as the root user, but files cannot be owned by it. The mysqld process requires all … Read more

Which command set would make the slave current?

Correct Answer for the Question – Which command set would make the slave current? is given below Which command set would make the slave current? STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE; STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383; STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE; STOP SLAVE; CHANGE MASTER TO … Read more

Is it true that binary backups always take less space than text backups?

Correct Answer for the Question – Is it true that binary backups always take less space than text backups? is given below Is it true that binary backups always take less space than text backups? Yes, because binary backups only contain data, and not statements required to insert data into the tables. No, because text backups … Read more

Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

Correct Answer for the Question – Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows? is given below Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows? –tab –single-transaction –quick –skip-buffer Correct Answer The Correct Answer … Read more

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave?

Correct Answer for the Question – Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? is given below Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? Change the replication mode to MIXED before issuing any delete statements … Read more

You have created a new user with this statement:

Correct Answer for the Question – You have created a new user with this statement: is given below You have created a new user with this statement: When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt. When ‘erika’@’localhost’ tries to log … Read more

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

Correct Answer for the Question – Which statement is true about using Microsoft Windows Cluster as a platform for MySQL? is given below Which statement is true about using Microsoft Windows Cluster as a platform for MySQL? It relies on the shared disk architecture being visible to both servers. It is provided by means of IP-level … Read more

Which statement describes the activation of that access for the user?

Correct Answer for the Question – Which statement describes the activation of that access for the user? is given below Which statement describes the activation of that access for the user? The access does not take effect until the user logs out and back in. The access does not take effect until the next time the … Read more

Which step do you perform to create the contents of the data directory?

Correct Answer for the Question – Which step do you perform to create the contents of the data directory? is given below Which step do you perform to create the contents of the data directory? Run the create_system_tables.sql file Run the mysql_unpack.sql file Invoke mysqld with the –initialize option. Invoke mysql with the –initialize option. Correct … Read more

When they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

Correct Answer for the Question – When they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how? is given below When they roll back large transactions, the time … Read more