Question
Download Solution PDFIn SQL decimal data type, _______ indicates the maximum number of digits to the right of decimal point.
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFConcept
Float
Float is the Approximate-number data type, which means that not all values in the data type range can be represented exactly.
Scale
The scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
Precision
Precision is the number of digits in a number.
Fraction
It is not a data type in SQL but used with Time datatype to represent nanoseconds
Therefore option 2 is correct
Last updated on Jun 6, 2025
-> The HTET TGT Applciation Portal will reopen on 1st June 2025 and close on 5th June 2025.
-> HTET Exam Date is out. HTET TGT Exam will be conducted on 26th and 27th July 2025
-> Candidates with a bachelor's degree and B.Ed. or equivalent qualification can apply for this recruitment.
-> The validity duration of certificates pertaining to passing Haryana TET has been extended for a lifetime.
-> Enhance your exam preparation with the HTET Previous Year Papers.