PrepAway - Latest Free Exam Questions & Answers

In the world of SQL relational database, a timestamp usually comprises of (choose all that apply.

In the world of SQL relational database, a timestamp usually comprises of (choose
all that apply.

PrepAway - Latest Free Exam Questions & Answers

A.
DATE

B.
TIME

C.
Signed

D.
Float

E.
Decimal

Explanation:
Memorize this listSMALLINT 16-bit signed integer
INTEGER 32-bit signed integer
DECIMAL(p,q. Signed decimal number, p digits, q decimals
FLOAT(p. Floating point number of p bits precision
CHAR Fixed length string of n characters
VARCHAR(n. Variable length string up to n characters
DATE Date ( in the form yyyymmmmdd.
TIME Time (in the form hhmmss.
TIMESTAMP Combines a DATE and a TIME


Leave a Reply