Terminologies In Database

When dealing with databases, a row is a;

• a. Link

• b. router

• c. record

• d. column

A foreign key is;

• a. A composite key in a table

• b. A candidate key

• c. A field in one table that is used as a secondary key in another table

• d. A field or collections of fields in one table that refers to the primary key in another table

What is a column when dealing with databases?

• a. An upright pillar

• b. A vertical group of cells, within a table

• c. A group of adjacent cells

• d. Items stored horizontally in a database

Datatype refers to;

• a. A data item, defined by the values it can take

• b. Monies that I have saved

• c. The number of rows and columns in a database

• d. The number of records used to store data in a database

5. Name a data type found in databases

• a. Primary key

• b. table

• c. Row (record)

• d. Date/Time

Why is a primary key important?

• a. Because it’s the first key in the table

• b. Because there are too many keys in the database

• c. Because it serves as a unique identifier for a row of data.

• d. Because it allows you to open the entire database.

A secondary key is;

• a. A candidate key until the primary key is selected

• b. A second way to open the Lab door

• c. A second table in a database

• d. Two columns with the same data in a database

The name of the datatype that uses numbers is called;

• a. Number

• b. Logical

• c. textual

• d. Date/time