A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A.The sync_relay_log=1000setting on the slave is too small.
• B.enforce_gtid_consistency=ONand consistency is broken between the master and the slave.
• C.binlog_format=STATEMENTand a non-deterministic query was executed.
• D.sync_binlog=0and the master server crashed.
• E.binlog_cache_size=1024is too small and transactions are lost.

Comment: *

Name: *

Email: *

Verification: *

After rebooting the host, you attempt to start the mysqldservice. 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 network service process in the server is frozen, so all TCP/IPconnections are paused and cannot be reused.
• B.The mysqldservice has already been started on the same port.
• C.You failed to specify the port number 3306to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
• D.The /etc/hostsfile does not have a valid IP entry for mysqld localhost, so it is binding to
  127.0.0.1, which is already in use.
• E.The mysql.sockfile in the MySQL /tmpdirectory was not removed after the reboot, so mysqldstill thinks there is an active server running.

Comment: *

Name: *

Email: *

Verification: *

Consider:

Which statement best describes the meaning of the value for the key_len column?

• A.It shows the total size of the index row.
• B.It shows how many columns in the index are examined.
• C.It shows how many bytes will be used from each index row.
• D.It shows the number of characters indexed in the key.

Comment: *

Name: *

Email: *

Verification: *

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A.sync_binlog=0 and the master server crashed.
• B.enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
• C.binlog_cache_size=1024 is too small and transactions are lost.
• D.binlog_format=STATEMENT and a non-deterministic query was executed.
• E.The sync_relay_log=1000 setting on the slave is too small.

Comment: *

Name: *

Email: *

Verification: *

When you examine a new MySQL installation with default configuration, you find a file called ibdata1in the database directory. Which two statements are true about this file? (Choose two.)

• A.it contains the binary log.
• B.it contains a general tablespace.
• C.it is the default location for all new tables that you create.
• D.it contains the system tablespace.
• E.it contains the redo log.
• F.it contains the undo log.

Comment: *

Name: *

Email: *

Verification: *