1Z0-874 Online Practice Questions and Answers

Assuming that the user account 'joe'@'example.com' exists, executing DROP USER

'joe'@'example.com' has the following consequences:

A. The user account will immediately be removed from the server, if no object-level privileges are in effect for that account

B. The account will be removed from the server the next time FLUSH PRIVILEGES is executed, if no object-level privileges are in effect for that account

C. The account and all associated privileges will immediately be removed from the server

D. The user account and all associated privileges will be removed from the server the next time FLUSH PRIVILEGES is executed.

As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement:

GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com'

Which of the following best describe the effects of issuing this statement?

A. The account is not created, as you must always specify a password for new users

B. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.

C. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.

D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login

E. There is not enough information provided to determine the outcome of executing that statement.

Which of the following best describes the purpose of the max_allowed_packet parmeter, and when it is set?

A. The max_allowed_packet parameter is set per-connection.

B. The max_allowed_packet parameter is global and is only set by shutting down the server.

C. The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.

D. The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.

Which of the following best describe how access control occurs in MySQL?

A. On login, the username, hostname and password are checked to allow access. On every query execution, the username, hostname and current object access permissions are checked.

B. On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname, password and current object access permissions are checked.

C. On login, the username, hostname and password are checked to allow access and the object access permissions at login time are used for all subsequent operations for the lifetime of the connection.

Granting access to the mysql database...

A. Should never be done for any users.

B. Should always be done for all users.

C. Should only be done on administrator accounts.

D. Should be done for anyone needing to create views

Which of the following are reasons you would want to normalize your data?

A. It removes redundant data.

B. It is the only way to make your data internationalized.

C. It makes data access more flexible.

D. It helps eliminate possible data inconsistencies.

E. It makes backups more efficient.

Consider the following:

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

| id | PartName | Location |

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

| 1 | 40GB Hard Drive | Jacksonville |

| 2 | 1GB DDR | Atlanta |

| 3 | Keyboard | San Jose |

| 4 | Monitor | Harrisburg |

| 5 | USB Drive | Miami |

| 6 | DVD/R | Jacksonville |

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

Which of the following best describes why this table should be split into a part and location table?

A. Because it has redundant location values.

B. Because it has multiple repeating groups in each row.

C. This table should not be split as it is already in third normal form.

Which of the following is true of the table cache if you mainly run simple queries on many tables?

A. The table cache should be decreased.

B. The table cache should be increased.

C. The table cache should not be changed.

When should you enable the Query Cache?

A. A lot of repeating and identical SELECT queries are received by the server.

B. The underlying tables don't change very often.

C. The server machine has more than one CPU.

D. The server machine has more than one network interface.

Which of the following best describes what mysqldumpslow does and how to use it?

A. It shows a summary of the slow log contents.

B. It dumps the contents of the slow log into a readable format.

C. shell> mysqldumpslow log_name

D. shell> mysqldumpslow < log_name