When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one
of the integer datatypes.
A.
BIT columns are written by InnoDB at the head of the row, meaning they are always the first to
be retrieved.
B.
Multiple BIT columns pack tightly into a row, using less space.
C.
BIT (8) takes less space than eight TINYINT fields.
D.
The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, < <, and >>. The other
integer types cannot.
...
继续阅读
(41)