Free 1Z0-874 Web TestEngine Demo

Q15 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

1Z0-874 Web TestEngine demo