Oracle 1Z0-874 dumps - 100% Pass Guarantee!

In replication the master server logs updates to this/these databases by default: A. No database.

B. The default database

C. The mysql database

D. All databases

E. All databases but mysql

When working with replication, why might you want to stop the SQL thread on the slave while keeping the I/O thread running?

A. So that no changes are made while making backups.

B. So that events for the slave do not get backlogged on the master.

C. So that remaining events can be processed while not receiving new events from the master.

Why should log files be secured against reading by non-authorized users?

A. Data values may be read

B. Usernames and passwords could be revealed.

C. Unauthorized users may alter the log contents.

D. The server may be prevented from writing to the log file

Given the result of the following query:

mysql> SELECT Host, User FROM mysql.user WHERE User='joe';

+-------------+------+

| Host | User |

+-------------+------+

| % | joe |

| example.com | joe |

+-------------+------+

2 rows in set (0.00 sec)

A client connection is established with the username joe from the host example.com.

Assuming that the login is successful, which of the entries shown in the mysql.user table are used to authenticate the client connection for subsequent query executions, and why?

A. The 'joe'@'%' account is used for all authentication, as MySQL will always use the most general host name possible.

B. The 'joe'@'example.com' account is used for all authentication, as MySQL will always use the most specific hostname possible.

C. For every query, the 'joe'@'example.com' account is checked first. If that does not have the proper permissions, 'joe'@'%' will be used as MySQL will check all relevant accounts, with the most specific hostname first.

D. For every query, the 'joe'@'%' account is checked first. If that does not have the proper permissions, 'joe'@'example.com' will be used as MySQL will check all relevant accounts, with the most general hostname first.

It is important to analyze queries that involve joins with EXPLAIN because...

A. Joins are more prone to mistakes.

B. Using EXPLAIN before executing the query helps the server prepare the statements used.

C. Joins have the potential to cause more server processing if not defined correctly.