Which datatype is used for a fixed length binary string?

Solution (By Examveda Team)

This question is asking about the data type used in MySQL to store a fixed length of binary data. Let's break down the options:
Option A: VARCHAR: This data type is used for variable-length strings, meaning the length can change. It's not suitable for fixed-length binary data.
Option B: BINARY: This is the correct answer! BINARY is used to store a fixed-length string of binary data.
Option C: VARBINARY: Similar to VARCHAR, this data type is for variable-length binary data.
Option D: BLOB: BLOB is used for storing large binary objects, like images or documents. It's not designed for fixed-length strings.
Therefore, the correct answer is Option B: BINARY.