Data Types Flashcards Preview

SQL > Data Types > Flashcards

Flashcards in Data Types Deck (9)
Loading flashcards...
1

Foreign key

FK

2

Primary key

PK

3

Fixed-length character data, 1 to 255 characters

CHAR

4

Variable-length character data, 1 to 2,000 characters. VARCHAR is automatically converted to VARCHAR2 in Oracle.

VARCHAR

5

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.

NUMBER

6

Numeric data. DBMSs that do not support the NUMBER data type typically use NUMERIC instead.

NUMERIC

7

Integer values only. INT is automatically converted to NUMBER in Oracle.

INT

8

Small integer values only. SMALLINT is automatically converted to NUMBER in Oracle.

SMALLINT

9

DATE formats

DD-MON-YYYY, DD-MON-YY, MM/DD/YYYY, and MM/DD/YY