Exam Dumps VCE

Q21. Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

Q22. You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)

Q23. Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)

Q24. Consider the table people with this definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)

Q25. You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

Q26. Why should you be selective when granting the PROCESS privilege to an account?

Q27. A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

Q28. What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

Q29. You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default –basedir value) for your operating system. Which step should you perform before defining your own databases and database tables?

Q30. When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

Q31. You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

Q32. You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

Q33. MySQL is installed on a Linux server and has this configuration:
[mysqld]
user=mysql
datadir=/data/mysql/
As the ‘root’ user, you change the datadir location by executing:
shell> cp -R /var/lib/mysql /data/mysql/
shell> chown -R mysql /data/mysql
What is the purpose of changing ownership of datadirto the ‘mysql’ user?

Q34. You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

Q35. Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query?

Q36. Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

Q37. You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

Q38. A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?

Q39. Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Q40. Which statement describes how the relay log works?

Q41. You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

Q42. Consider:

What does the range value in the type column mean?

Q43. Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server’s health and performance?