Session Score
Membership
Navigate
|
Current Topic: View Topic Tree |
Everything > Science & Technology > Computers > Programming > SQL |
|---|
In the SQL programming language, which of the following data types should be used to hold a whole number that can vary in the range of -2 billion to +2 billion?
|
INT |
|
FLOAT |
|
|
TEXT |
|
|
VARCHAR |
|
|
DATE |
Explanation
In the SQL programming language, INT is the data type that should be used to hold a whole number that can vary in the range of -2 billion to +2 billion. The following are commonly used data types:
FLOAT - used to hold a single-precision floating point number.
INT - used to hold an integer number.
VARCHAR - used to a hold a small text string within a fixed number of characters.
TEXT - used to a hold a variable length text string of up to 64K characters.
DATE - used to hold a date with a format of YYYY-MM-DD in the range of 1000-01-01 to 9999-12-31.
There are many other more specific data types.
Please rate this question and explanation .... ( takes you to the next question >>> )
|
|
|
|
Info
Admin Functions