1Z0-874 Real Exam Questions and Verified Answers

Question 1 Single choice

Which of the following best describes what you might expect after disabling InnoDB at run time?

A
It will disable InnoDBs associated memory buffers and data structures, however it will not save any memory.
B
It will still enable InnoDBs associated memory buffers and data structures, however it will save memory.
C
It will disable InnoDBs associated memory buffers and data structures, which will save memory.

Show answer and explanation

Correct answer: C

Question 2 Single choice

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.

Show answer and explanation

Correct answer: B

Question 3 Single choice

Which of the following best describes why one should use VARCHAR rather than CHAR in InnoDB?

A
The average amount of space used will be less.
B
Generally, there will be less disk I/O during processing.
C
VARCHAR columns provide better transaction support.
D
The optimizer always performs better with VARCHAR columns over CHAR columns.

Show answer and explanation

Correct answer: B

Question 4 Single choice

Which of the following best describes how the binary log might be helpful in query optimization?

A
By checking which queries it logs as slow.
B
By checking the processor load it records when a query is executed.
C
By identifying the WHERE clauses in queries for which indexes might be useful.

Show answer and explanation

Correct answer: C

Question 5 Single choice

You need to allow the user 'joe'@'example.com' the privilege to create and alter stored routines in the world database, but you do not want that user to be able to change any table definitions. The user already has the required permissions to access table data in the database.

Which of the following will achieve that?

A
mysql> GRANT ALL ROUTINE PRIVILEGES ON world.* TO 'joe'@'example.com';
B
mysql> GRANT ALL PRIVILEGES ON world.* TO 'joe'@'example.com';
C
mysql> GRANT ALL PRIVILEGES ON PROCEDURE world.* TO 'joe'@'example.com';mysql> GRANT
ALL PRIVILEGES ON FUNCTION world.* TO 'joe'@'example.com';
D
mysql> GRANT CREATE ROUTINE ON world.* TO 'joe'@'example.com';mysql> GRANT ALTER
ROUTINE ON world.* TO 'joe'@'example.com';
E
You must use GRANT ALL PRIVILEGES ON world.routine1_name, world.routine2_name ... TO 'joe'@'example.com', replacing routine1_name etc. with the names of each of the stored routines the user may want to create or alter
F
This cannot be done; permissions on tables and stored routines are always shared.

Show answer and explanation

Correct answer: D

Question 6 Single choice

Consider the following:

mysql> EXPLAIN SELECT Name FROM Country WHERE Population BETWEEN 1 AND 10000\G

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

id: 1

select_type: SIMPLE

table: Country type:

range possible_keys:

i_pop key: i_pop

key_len: 4

ref: NULL

rows: 10

Extra: Using where

What is the meaning of the range value of the type column?

A
There is a range of indexes that can be used.
B
The type of index uses the range algorithm.
C
The index is used to select rows that fall between a range of index values.
D
The optimizer has determined that only data from the very beginning or the very end of the table is
needed

Show answer and explanation

Correct answer: C

Question 7 Single choice

Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.

A
true
B
false

Show answer and explanation

Correct answer: B

Question 8 Single choice

In regards to security, which of the following statements are true?

A
mysqld should not be run as root or administrator.
B
mysqld should be run as root or administrator.
C
The user owning the server process should own all files and directories to which the server may write.
D
The root or admininistrator users should own all files related to the server process

Show answer and explanation

Correct answer: A

Question 9 Multiple choice

Which of the following statements are true regarding the slow query log?

A
The slow query log can be switched on with the log_slow_queries option.
B
The slow query log is always enabled.
C
The slow query log contains queries that don't utilize any index.
D
To have the slow query log contain queries that don't utilize any index, the log-queries-not-using- indexes option needs to be set.
E
The slow query log will contain queries that take more than 10 seconds.
F
The slow query log will contain queries that take more seconds than configured in the long_query_time option.
G
You can use the mysqldumpslow command line tool to summarize the content of the slow query log.
H
You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.

Show answer and explanation

Correct answers: A, B, F, H

Question 10 Single choice

Consider the following:
mysql> SHOW STATUS LIKE 'Qcache%';

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

| Variable_name | Value |

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

| Qcache_free_blocks | 87 |

| Qcache_free_memory | 318442 |

| Qcache_hits | 11224 |

| Qcache_inserts | 19215 |

| Qcache_lowmem_prunes | 437 |

| Qcache_not_cached | 9155 |

| Qcache_queries_in_cache | 240 |

| Qcache_total_blocks | 924 |

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

What can be derived from this output?

A
There is a low utilization of the query cache.
B
There is a normal utilization of the query cache.
C
There is a high utilization of the query cache.

Show answer and explanation

Correct answer: A