Which data type is designed to store fixed-length binary data in SQL Server?

Options

  • A. VARCHAR
  • B. VARBINARY
  • C. BINARY
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. BINARY

Detailed Explanation

  • BINARY: Stores fixed-length binary data in SQL Server.
  • VARBINARY: Stores variable-length binary data.
  • These types are useful for storing binary values such as hashes and encoded content.