COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Data type used to store currency value and numeric data used in mathematic calculations involving data with one to four decimal places
|
|
Numeric
|
|
|
Currency
|
|
|
Short text
|
|
|
Long text
|
Explanation:
Detailed explanation-1: -To store money amounts in MySQL, the best choice is to use DECIMAL data type or NUMERIC type. Float data type is not a good choice for money amounts. It gives some rounding errors. Therefore, avoid float for money amounts.
Detailed explanation-2: -The data types NUMERIC, DECIMAL, INTEGER, BIGINT, and SMALLINT are exact numeric types.
There is 1 question to complete.