2. List AT LEAST three different Data Types in SQL, Explain What each is, When to use each, and how each is defined is SQL.
|
Data
Type |
Description |
Usage |
SQL
Definition |
|
Characters |
A Single Character |
Display |
CHAR (1) |
|
Strings |
An array of Characters |
Display |
CHAR (N) VARCHAR (N) VARCHAR2 (N) LONG VARCHAR (N) |
|
Integers |
Whole Numbers |
Calculations |
INTEGER NUMBER (N) SMALLINT |
|
Real Numbers |
Decimal/floating Points |
Calculations |
DECIMAL (M,N) |
|
Arrays |
A Grouping of Data Types (all elements of the same
type) |
Various |
Combinations |
|
Structures or Records |
A Grouping of DIFFERENT Data Types |
Database Storage |
Combinations |
|
Dates |
Date and Time |
Display and Calculations |
DATE |
|
Graphics |
Graphic Files |
Display |
BLOB CLOB BFILE |
|
Hyperlinks |
URLs |
Internet/Storage Transfers |
|