Oracle MySQL 5.7 Database Administrator - 1Z0-888 FREE EXAM DUMPS QUESTIONS & ANSWERS
You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?
Which statement is true?
Correct Answer: B
Vote an answer
Which three statements correctly describe MySQL InnoDB Cluster?
Correct Answer: B,D,F
Vote an answer
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:
You execute a `SHOW CREATE TABLE mytable" on the slave:
The table mytable on the slave contains:
You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
You execute a `SHOW CREATE TABLE mytable" on the slave:
The table mytable on the slave contains:
You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
Which two conclusions can be made based on the output of the query?
Correct Answer: A,C
Vote an answer
What two statements are true regarding FLUSH TABLES FOR EXPORT?
Correct Answer: D,E
Vote an answer
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?
Correct Answer: D
Vote an answer
Which two statements are true regarding MySQL security? (Choose two.)
Correct Answer: A,C
Vote an answer
Which three are key advantages of standard MySQL replication?
Correct Answer: D,E,F
Vote an answer
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.)
[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.)
Correct Answer: B,C,D
Vote an answer