MYSQL 1Z0-874 Actual Free Exam Questions & Community Discussion

Which of the following best describes the order in which MySQL considers host names and user names when a client attempts connection?

Which key buffers are available for MyISAM tables?

Consider the following:
mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'
*************************** 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 the possible_keys column in this output denote?

When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?

Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?

Which of the following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database?

Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides? (Choose two)

In the following query, the Population column is indexed: mysql> EXPLAIN SELECT Name -> FROM Country -> WHERE Code LIKE '%B%' AND Population > 10000 *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: ALL possible_keys: i_pop key: NULL key_len: NULL ref: NULL rows: 239 Extra: Using where
Which of the following best describes how to deal with the key value of the EXPLAIN output? (Choose two)