Free 1Z0-882 Web TestEngine Demo

Q10 Multiple choice

An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code.

Example: "ABCDEFOO ooozzz comments will be here FIELDS----FIELD64"

Given the query pattern: SELECT----FROM sensors WHERE details LIKE `ABCDEF

Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

Select all that apply.

A
ALTER TABLE sensors ADD KEY (details ) USING BTREE
B
ALTER TABLE sensors ADD KEY (details) USING HASH
C
ALTER TABLE sensors ADD KEY (details) USING BTREE
D
ALTER TABLE sensors ADD KEY (details )USING HASH
E
ALTER TABLE sensors ADD FULLTEX (details)

1Z0-882 Web TestEngine demo