COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Numeric
|
|
|
Currency
|
|
|
Short text
|
|
|
Long text
|
Detailed explanation-1: -Use the Currency data type for a field requiring many calculations involving data with one to four decimal places. Single and Double data type fields require floating-point calculation. The Currency data type uses a faster fixed-point calculation.
Detailed explanation-2: -The MONEY data type stores currency amounts. TLike the DECIMAL(p, s) data type, MONEY can store fixed-point numbers up to a maximum of 32 significant digits, where p is the total number of significant digits (the precision) and s is the number of digits to the right of the decimal point (the scale).
Detailed explanation-3: -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.
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.