1Z0-874 Online Practice Questions and Answers

How can stored routines be used to check for constraints or legality of incoming data?

A. They can make use of the VALIDATE DEFINER setting.

B. They can not be used to check for constraints or legality of data.

C. They can check and only perform an action if the incoming values match a specified value.

What are reasons to prefer using GRANT and REVOKE statements over editing the privilege tables directly?

A. Using GRANT and REVOKE allows the server to figure out the right tables and do all the appropriate work

B. All grant tables in memory are immediately updated on GRANT and REVOKE

C. Making changes directly to the grant tables, one must remember to execute flush privileges to make the changes take effect

D. GRANT and REVOKE statements allow you to do more fine-grained tuning of user privileges than does editing the grant tables directly.

E. None of the above

In order to create an account where no username is needed for login, ...

A. the account should be created with a username consisting of the empty string

B. the account should be created with the username "anon"

C. the account should be created with the username "%"

D. Accounts cannot be specified in a way such that no username is required

E. None of the above

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.

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.

Why should one preferably group multiple statements for InnoDB tables within a transaction whenever it is possible?

A. It minimizes bandwidth usage.

B. It helps keep log file sizes down.

C. It minimizes the amount of flush operations needed.

D. It helps reduce the chance of the transaction failing due to a bad query.

By default, mysqld's memory settings are...

A. There are no default memory settings for mysqld.

B. Set to a median value good for overall general use.

C. Rather consuming and should be decreased if possible.

D. Rather conservative and should be increased if possible.

Which of the following disk characteristics are most important to a database server and why?

A. Disk size, because a database needs a lot of storage space.

B. Transfer rate, because the database needs to be able to transfer the data off the disks at a very high rate.

C. Disk seek time, because it is more important for the heads of the disk to move quickly from track to track.

Which of the following are methods to improve performance?

A. Spreading single tables to different disks pointed to by a symbolic link.

B. Spreading whole databases to different disks pointed to by a symbolic link.

C. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.

D. Moving less needed parts of the MySQL install such as the documentation or the test files to different disks pointed to by a symbolic link.

What kind of replication is supported by the MySQL server?

A. Multiple-master replication

B. Master to slave replication

C. Single file based clustering

D. MySQL doesn't support replication