DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
integer
|
|
|
float
|
|
|
string
|
|
|
boolean
|
Detailed explanation-1: -The INTEGER data type stores whole numbers that range from-2, 147, 483, 647 to 2, 147, 483, 647 for 9 or 10 digits of precision. The number 2, 147, 483, 648 is a reserved value and cannot be used. The INTEGER value is stored as a signed binary integer and is typically used to store counts, quantities, and so on.
Detailed explanation-2: -The datatype quantity is for property values that describe quantities, in particular physical quantities such as time or distance.
Detailed explanation-3: -The integer data type represents a positive whole number or its negative value. Examples of integers are 0, 1, 2, 3 and 4 .
Detailed explanation-4: -The best type for price column should be DECIMAL. The type DECIMAL stores the value precisely. For Example-DECIMAL(10, 2) can be used to store price value. It means the total digit will be 10 and two digits will be after decimal point.