Database Basics

The data type consisting of text consisting of letters, numbers and/or symbols up to 255 characters is called:

• Short Text

• Long Text

• String

• Text Type

The text type consisting of Text consisting of letters, numbers and/or symbols up to 64,000 characters is called

• Short Text

• Long Text

• String

• Paragraph

To store a grade or temperature the data type would be

• Integer

• Real Number

• Number

• Whole Number

You want to store the price of the products at your cake sale, you will use

• Number

• Price

• Currency

• Expenses

To store the birthdays of all Jumeirah College students, the secretary will use a field of type

• Date

• Date of Birth

• Date/Time

• Calendar

You need to store whether people have paid for their order or not, you use a field of type

• Yes/No

• Maybe

• True/False

• Question

You want the Database program to create a new number each time a new record is added, you use datatype

• Generate

• NewNumber

• Autonumber

• Automatic

A new table contains: first name, surname, date of birth, address, paid or not. List the data types to be used

• Short text, Long text, Date/Time, Long Text, Yes/No

• Short text, Short text, Date/Time, Long Text, Yes/No

• Short text, Short text, Date, Long Text, Yes/No

• Short text, Short text, Date/Time, Short Text, Yes/No

The table above has no Primary key, what is an easy and quick solution?

• Add a field called ID of datatype Number and type in data for the ID's. Make this field the Primary Key

• Add a field and make it an Autonumber and Primary Key

• Set the Date of Birth as the Primary Key

• Set the First Name and Surname as a combined Primary Key

An advantage of a computerized database is that

• You can query it and obtain specific data that is relevant to your requirements

• You can enter lots and lots of data and never run out of space

• Anybody can access the data and use it

• It's easy to use and you never need to worry about it again