COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Whole numbers
|
|
|
Decimal numbers
|
|
|
Strings
|
|
|
Yes / No ____ True / False
|
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 INT data type is a synonym for INTEGER. The INT8 data type stores whole numbers that can range in value from –9, 223, 372, 036, 854, 775, 807 to 9, 223, 372, 036, 854, 775, 807 [or-(2 63-1) to 2 63-1], for 18 or 19 digits of precision.
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 . The float data type represents a floating-point or decimal number.
Detailed explanation-4: -Numeric Data Types The precision is a positive integer that determines the number of significant digits in a particular radix. The data types NUMERIC, DECIMAL, INTEGER, BIGINT, and SMALLINT are exact numeric types. An integer has a scale of zero, but the syntax simply uses the word INTEGER or the abbreviation INT.
Detailed explanation-5: -In computer science, an integer is a datum of integral data type, a data type that represents some range of mathematical integers. Integral data types may be of different sizes and may or may not be allowed to contain negative values. Integers are commonly represented in a computer as a group of binary digits (bits).