Information Systems and Databases Flashcards Preview

IPT (Information Process Technology) > Information Systems and Databases > Flashcards

Flashcards in Information Systems and Databases Deck (9)
Loading flashcards...
1
Q

What are the 8 most common field data types?

A

Integer, Decimal/Fixed Point, Real/Float, Money/Currency, Boolean/Bit, Date/Time, Text/Char and Binary/BLOB.

2
Q

What is an Integer data type?

A

Exact whole numbers (both negative and positive)

3
Q

What is a Decimal/Fixed Point data type?

A

Exact fixed decimal point numbers with limited precision. A scale of an integer data type.

4
Q

What is a Real/Float data type?

A

Approximate fractional numbers with a very large range.

5
Q

What is a Money/Currency data type?

A

Exact, essentially an integer scaled to have four decimal places and optimised for financial accuracy.

6
Q

What is a Boolean/Bit data type?

A

Yes/No or True/False data.

7
Q

What is a Date/Time data type?

A

A number representing the days since (or prior to) a specific date.

8
Q

What is a Text/Char data type?

A

String data represented as a sequence of individual characters.

9
Q

What is a Binary/BLOB data type?

A

Raw binary data. Used for storing images, audio or other non-numeric or text data.