Introduction to DBMS

Which datatype is most suitable for the following:

7

• TEXT

• CURRENCY

• NUMBER

• DATE/TIME

WHICH DATA TYPE IS SUITABLE FOR:

YES/NO

• NUMBER

• TEXT

• DATE/TIME

• LOGICAL

WHICH DATATYPE IS MOST SUITABLE FOR THE FIELD:

FIRST NAME

• LOGICAL

• TEXT

• NUMBER

• CURRENCY

WHICH DATATYPE IS SUITABLE FOR CREATING A FIELD FOR DATE OF BIRTH?

• LOGICAL

• NUMBER

• TEXT

• DATE/TIME

_____________ is used to uniquely identify each record in a database.

A primary key in one table and is reused in another table is called a/an ________________________.

A row is also referred to as a/an ________________.

while a column is referred to as a/an ______________________.

The view that displays the data dictionary/table structure is called:

• Design view

• Datasheet view

The view that displays the full table is known as:

• Design View

• Datasheet view