Database Management

A database is any program that is used to ________________, _________________, and _________________ data and control who has access to it.

• release

• store

• retrieve

• modify

• manage

What is the purpose of a data type in a database?

• It is used to state what the name of the field will be.

• It will be used to state the type of data that the data will store.

• It will state how long the text should be .

• I will state what type of data should be stored in each field/column.

The smallest piece of data that can be stored ?

• record

• feilds

• records

• none of the above

Another name for a record is:

• record

• column

• field

• none of the above

A primary key is used to uniquely identify records in a database. Choose the best field to use as a primary key

• Address

• Full Name

• Social Security Number

• Profession

What is a foreign key?

• A blurry relationship that exist between two tables

• The key that is used to draw a line between both tables

• The way in all tables and the user will communicate

• A composite key in one table and a local key in another table.

• None of the above

If there is a common field between two tables, this means that a ________________ can be formed.

• Linking

• Joining

• Relationship

• Meshing

One advantage of a DBMS is :

• Can be expensive to change old system to new

• Great when you have old persons working with

• Can retrieve information quickly and easily

• Training is needed.

What does DBMS mean?

• Database Managing Symster

• Datasytem Management System

• Datafield Modifiy system

• Database Management System

A table is a collection of rows and columns that have cell addresses

• True

• False