Examveda

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision . . . . . . . .

A. 32

B. 64

C. 65

D. 16

Answer: Option C

Solution (By Examveda Team)

This question is about DECIMAL data type in MySQL. DECIMAL is used to store exact numeric values, which means numbers with a fixed number of decimal places.
The question asks about the digit precision of DECIMAL when used with expressions containing only exact values with fractional parts.
This means we are working with numbers like 1.2345, 0.0001, etc.
In such cases, MySQL uses a default precision for DECIMAL.
Let's look at the options:
* Option A: 32 * Option B: 64 * Option C: 65 * Option D: 16
The correct answer is Option B: 64.
This means that DECIMAL can hold up to 64 digits of precision for exact values with fractional parts in MySQL.
Remember: This is the default precision. You can specify a different precision using the DECIMAL(M, D) syntax, where M is the total number of digits and D is the number of digits after the decimal point.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous