The number of binary string types among the following is . . . . . . . .
BINARY, VARBINARY, BLOB, CHAR
BINARY, VARBINARY, BLOB, CHAR
A. 1
B. 2
C. 3
D. 4
Answer: Option C
Solution (By Examveda Team)
This question asks about data types in MySQL that can store binary data. Let's break down each option:BINARY: This data type stores fixed-length binary strings. It's designed to hold raw data.
VARBINARY: This data type stores variable-length binary strings. It's flexible and can store different lengths of binary data.
BLOB: This data type stores large binary objects (BLOBs). It's ideal for images, audio, or other large files.
CHAR: This data type stores fixed-length character strings. It's not meant for binary data.
Therefore, the correct answer is Option C: 3.
The three data types that can store binary strings are:
* BINARY
* VARBINARY
* BLOB
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion