Q923
What is the datatype for single precision floating point number?
A.
FLOAT
AnswerB.
DOUBLE
C.
INT
D.
BIGINT
Answer: Option A
Solution
Answer: Option A
Solution:
This question is asking about how MySQL stores numbers with decimal points. Think of it like this:
* FLOAT is for numbers that don't need super high precision (like 3.14159). They are like small, quick calculators.
* DOUBLE is for numbers that need extra accuracy, like for scientific calculations (think really long decimals). They are like high-powered calculators.
* INT and BIGINT are for whole numbers (no decimal points) that are small (INT) or big (BIGINT).
So, the answer is Option A: FLOAT.