Question

In MYSQL, which type of value should not be enclosed within quotation marks?

• A. DATE
• B. VARCHAR
• C. FLOAT
• D. CHAR

Hint:

Numbers in MYSQL do not need quotes,
but strings and date literals must be enclosed.

Answer 1

The Correct Option is C

In MYSQL, values for string data types like CHAR and VARCHAR
must be enclosed within quotation marks — either single or double quotes.
DATE values are also written in quotes,
because they are treated as string literals representing a date format.
However, numeric data types like FLOAT or INT
should be written without quotes.
If a number is enclosed in quotes, it is treated as a string,
which can cause data type mismatches and errors in queries.
Therefore, the correct answer is FLOAT.