1Z0-874 Online Practice Questions and Answers

Privileges for using stored routines can be specified at the following levels:

A. Server-wide

B. Per database

C. Per routine

D. The ability to use stored procedures is not governed by the privilege system.

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.

When creating a new user account, which of The following are valid ways of specifying the hostname part of the account?

A. Leaving it unspecified, allowing connections from any host

B. Using localhost

C. Using a hostname, such as agric.comp1.com

D. Using an IP address, such as 100.160.1.47

E. Using a hostname pattern with wildcards, such as %.comp1.com

F. Using an IP number with wildcards, as 100.160.1.%

G. Using an IP number/netmask combination such as 100.160.0.0/255.255.0.0

H. User accounts do not contain a hostname part

Is it ever safe to start the MySQL server as root?

A. No it is never safe to start it as root.

B. Yes it is always safe to start it as root.

C. Yes provided you make it switch the effective user to mysql.

D. No because you can not make it switch the effective user if started as root.

What should you do in order to enhance the security of a standard MySQL installation on Unix- type operating systems?

A. Disable the mysql_access program

B. Run the mysql_secure_installation script

C. Nothing; by default the security level of a MySQL installation is very high

Connection strings in FEDERATED tables are stored...

A. In variables.

B. Within the table definition.

C. In a .fed file corresponding to the table.

D. They are not stored, but must be re-specified at server restart.

mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL

key_len: NULL ref: NULL rows: 4079 Extra: Using where What does it mean that the possible_keys column value is NULL?

A. No index is considered available for this query.

B. No index exists for the table you are querying.

C. You are not making use of any available indexes in your query.

Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using where Which of the following best describes the meaning of the "id" column in the output from EXPLAIN?

A. Which process it is running as.

B. Which SELECT the row refers to.

C. It is just an incremental number to identify the rows from the output.

Consider the following:

mysql> DESC customers;

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

| Field | Type | Null | Key | Default | Extra |

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

| id | int(11) unsigned | NO | PRI | NULL | auto_increment |

| name_1 | char(20) | YES | MUL | NULL | |

| name_2 | varchar(20) | YES | | NULL | |

| name_3 | varchar(20) | YES | | NULL | |

| email | varchar(50) | YES | | NULL | |

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

mysql> EXPLAIN SELECT * FROM customers WHERE name_1 = 'Johnny'\G

*************************** 1. row ***************************

id: 1

select_type: SIMPLE

table: customers type:

ref

possible_keys: i_name_1_01,i_name_1_02

key: i_name_1_01

key_len: 21

ref: const

rows: 1

Extra: Using where

What can be assumed by looking at the key_len column?

A. No indexes are being used.

B. The full index is being used.

C. The partial index is being used.

D. The longest index is 21 characters long.

Which key buffers are available for MyISAM tables?

A. A global key buffer that keeps index information for all MyISAM tables.

B. An optional table-specific key buffer that can be assigned to single MyISAM tables.

C. An optional column-specific key buffer that can be assigned to a single column of a MyISAM table.

Which of the following would be considered a good candidate table for compression?

A. A table with data that needs only few updates in the future.

B. A table with data that will not be updated in the future.

C. A large table, such as those used for data warehousing.

D. All MyISAM tables are good candidates for compression.

Which of the following best describes the relationship between MAX_ROWS, AVG_ROW_LENGTH and the max table size?

A. MAX_ROWS * AVG_ROW_LENGTH tells MySQL how large you expect the table to grow to.

B. MAX_ROWS + AVG_ROW_LENGTH tells MySQL to not let the table grow past that size.

C. Specifying MAX_ROWS and AVG_ROW_LENGTH will prevent MySQL from growing the table beyond that limit.

D. Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.

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.

Which of the following best describe what could cause low utilization of query cache?

A. The query cache size is too small.

B. The CACHE_QUERY keyword is not being used.

C. The Qcache_priority variable is set too small.

D. The server might be trying to cache queries when it really isn't worth it.

Which of the following best describes what the connection backlog is and why it may need to be increased?

A. It may need to be increased on a server with a high rate of transactions.

B. The backlog is the queue of processes waiting to be processed on a server.

C. The backlog is the queue of network connections of clients waiting to connect.

D. It may need to be increased on a server with a high rate of client connections.