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?

• A.service mysqld prepare-init
• B.mysqld_safe --initialize ...
• C.mysql -u root -p < support-files/mysqldb.sql
• D.mysqld_safe --user=mysql
• E.mysqld --initialize ...

Comment: *

Name: *

Email: *

Verification: *

After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A.You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
  80, which is in use by the built-in web server.
• B.The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• C.The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to
  127.0.0.1, which is already in use.
• D.The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
• E.The mysql service has already been started on the same port.

Comment: *

Name: *

Email: *

Verification: *

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

• A.It allows a client to process scripts.
• B.It allows the use of stored routines.
• C.It allows a client to see another user's queries with the SHOW PROCESSLIST command.
• D.It allows a client to control running processes on a server.

Comment: *

Name: *

Email: *

Verification: *

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

• A.Increase the value of the innodb_read_io_threads option.
• B.Increase the value of the innodb_lock_wait_timeout option.
• C.Set the value of innodb_adaptive_hash_index to zero.
• D.Deactivate the query cache.
• E.Change the table to use HASH indexes instead of BTREE indexes.
• F.Increase the size of the InnoDB buffer pool.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about tablespaces?

• A.All tablespace files must be in the directory specified by the --datadir option.
• B.All tables must be in either the system tablespace or a general tablespace.
• C.The system tablespace can be configured to span multiple files.
• D.General tablespaces can be configured to span multiple files.

Comment: *

Name: *

Email: *

Verification: *