Which datatype means a variable length non binary string?
A. VARCHAR
B. BINARY
C. VARBINARY
D. BLOB
Answer: Option A
Solution(By Examveda Team)
In MySQL, the datatype that represents a variable-length non-binary string is VARCHAR.Let's analyze each option:
Option A: VARCHAR: This is the correct answer. VARCHAR stands for "variable character". It is used to store variable-length non-binary strings.
Option B: BINARY: This option is incorrect. BINARY is used to store fixed-length binary strings.
Option C: VARBINARY: This option is incorrect. VARBINARY is used to store variable-length binary strings.
Option D: BLOB: This option is incorrect. BLOB stands for "Binary Large Object" and is used to store large binary data.
Therefore, the correct answer is Option A: VARCHAR, as it represents the datatype for a variable-length non-binary string in MySQL.
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