nerdexam
Oracle

1Z0-883 · Question #56

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

The correct answer is B. Multiple BIT columns pack tightly into a row, using less space. See the full explanation below for the reasoning.

Question

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

Options

  • ABIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.
  • BMultiple BIT columns pack tightly into a row, using less space.
  • CBIT (8) takes less space than eight TINYINT fields.
  • DThe BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>.

How the community answered

(56 responses)
  • A
    4% (2)
  • B
    80% (45)
  • C
    11% (6)
  • D
    5% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice