Data Types Flashcards
1
Q
Foreign key
A
FK
2
Q
Primary key
A
PK
3
Q
Fixed-length character data, 1 to 255 characters
A
CHAR
4
Q
Variable-length character data, 1 to 2,000 characters. VARCHAR is automatically converted to VARCHAR2 in Oracle.
A
VARCHAR
5
Q
Numeric data. NUMBER(9,2) is used to specify numbers that have two decimal places and are up to nine digits long, including the decimal places. Some RDBMSs permit the use of a MONEY or a CURRENCY data type.
A
NUMBER
6
Q
Numeric data. DBMSs that do not support the NUMBER data type typically use NUMERIC instead.
A
NUMERIC
7
Q
Integer values only. INT is automatically converted to NUMBER in Oracle.
A
INT
8
Q
Small integer values only. SMALLINT is automatically converted to NUMBER in Oracle.
A
SMALLINT
9
Q
DATE formats
A
DD-MON-YYYY, DD-MON-YY, MM/DD/YYYY, and MM/DD/YY
