COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Autonumber
|
|
|
OLE Object
|
|
|
Numeric
|
|
|
Short Text
|
Detailed explanation-1: -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-2: -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.
Detailed explanation-3: -These types include the exact numeric data types ( INTEGER, SMALLINT, DECIMAL, and NUMERIC ), as well as the approximate numeric data types ( FLOAT, REAL, and DOUBLE PRECISION ). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED are synonyms for DECIMAL .