Information Systems and Databases

Question 1

What are the 8 most common field data types?

Answer 1

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

Question 2

What is an Integer data type?

Answer 2

Exact whole numbers (both negative and positive)

Question 3

What is a Decimal/Fixed Point data type?

Answer 3

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

Question 4

What is a Real/Float data type?

Answer 4

Approximate fractional numbers with a very large range.

Question 5

What is a Money/Currency data type?

Answer 5

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

Question 6

What is a Boolean/Bit data type?

Answer 6

Yes/No or True/False data.

Question 7

What is a Date/Time data type?

Answer 7

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

Question 8

What is a Text/Char data type?

Answer 8

String data represented as a sequence of individual characters.

Question 9

What is a Binary/BLOB data type?

Answer 9

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