Examveda
Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous