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: -NUMERIC Data Types. There are two different data types that allow us to store precise numerical data in SQL: NUMERIC and DECIMAL. Both of these types store decimal numbers and use exact arithmetic – as opposed to floating point numbers (REAL, FLOAT, etc.), which store binary numbers and use inexact arithmetic.
Detailed explanation-2: -Numbers that contain a decimal point are stored in a data type called REAL. Variables that use the real data type can accept both positive and negative numbers with a decimal place.
Detailed explanation-3: -Real values are written as standard floating point numbers with a period for a decimal point and no thousands separator.
Detailed explanation-4: -Floating-Point Data Type Floating-point data types are used to define variables that can hold real numbers.