Free 1Z0-874 Web TestEngine Demo

Q9 Single choice

Which of the following statements best describe the indexes supported by the MEMORY storage engine, and their general characteristics?

A
MEMORY tables only support HASH indexes which provide fast lookups that use a unique index.
B
MEMORY tables only support BTREE which provide better performance with non-unique index values and other comparison operators.
C
MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.
D
MEMORY tables support HASH indexes which provide better performance with non-unique index values and other comparison operators, and BTREE indexes which provide fast lookups that use a unique index.

1Z0-874 Web TestEngine demo