When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead
of one of the integer datatypes.

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.
The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>.
The other integer types cannot.

C.
Multiple BIT columns pack tightly into a row, using less space.

D.
BIT (8) takes less space than eight TINYINT fields.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *