Database

In a database table, rows are called

• Tables

• Fields

• Records

• Cells

In a database table, the columns are called

• File

• Fields

• Rows

• Cells

A field is one item of data such as name or address.

• True

• False

The most appropriate data type for the Barcode field

is

• Text

• Number

• Boolean

• Currency

The most appropriate data type for the Price field

is

• Text

• Number

• Boolean

• Currency

The most appropriate data type for the weight field is:

• Text

• Number

• Currency

• Boolean

The most suitable data type for storing phone number i.e. “977-1-1234567” is

• Text

• Number

• Currency

• Boolean

How many fields are there in this part of the database?

• 5

• 6

• 7

• 8

Primary key is

• A field that uniquely identifies each field in a file.

• A field that uniquely identifies each record in a file.

• A record that uniquely identifies each record in a file.

• A record that uniquely identifies each field in a file.

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

• Short text

• Long text

• Numeric

• Currency