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.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.
• B.The mysql service has already been started on the same port.
• C.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.
• D.The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• E.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.

Comment: *

Name: *

Email: *

Verification: *

You enable binary logging on MySQL Server with the configuration:
binlog-format=STATEMENT
log-bin
Which database updates are logged on the master server to the binary log by default?

• A.all updates to all databases
• B.all updates except to the PERFORMANCE_SCHEMA database
• C.all updates not involving temporary tables
• D.all updates to the default database, except temporary tables
• E.all updates except to the TEMPDB database

Comment: *

Name: *

Email: *

Verification: *

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

• A.Take a backup, stop the server, remove the data files, and restore the backup:
  
• B.Execute OPTIMIZE TABLEso that the InnoDB engine frees unused pages on disk back to the file system:
  
• C.Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
  
• D.Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
  

Comment: *

Name: *

Email: *

Verification: *

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

• A.validate_password_policy cannot be set without restarting the MySQL instance.
• B.validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• C.The dictionary file word list is too short.
• D.The validate_password plug-in has not been loaded.
• E.The name of the dictionary file is too obvious.
• F.The dictionary file is in an insecure location.

Comment: *

Name: *

Email: *

Verification: *

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

• A.log-master-updates
• B.rpl-recovery-rank
• C.server-id
• D.enable-master-start
• E.log_bin
• F.master-logging

Comment: *

Name: *

Email: *

Verification: *