Which SQL Server data type is used to store variable-length binary data?

Options

  • A. CHAR
  • B. VARBINARY
  • C. NCHAR
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. VARBINARY

Detailed Explanation

  • VARBINARY: Stores variable-length binary data.
  • It can store binary values of different lengths up to the specified maximum.
  • VARBINARY(MAX) can store large binary values.