Database Management 1(DBMS1): Summative Assessment

What is a database?

• a. A Website

• b. A place for fixing computers

• c. A repository of information that is related in some way

• d. My school

Why are field properties necessary?

• a. To add Restrictions or settings to fields

• b. To add a record in a database

• c. To find places to go in the database

• d. A table

Why is it necessary to create a proper database table structure?

• a. To have access to your data

• b. To make it easier, faster and with better controls to store and retrieve data.

• c. To make sure the database is stronger and all the data is safe

• d. To tell others what to do and how

What is a primary key?

• a. A secondary key in two fields in a table

• b. A field that does not identify a particular record

• c. A field that is a foreign key

• d. A field which uniquely identifies each row

When dealing with databases, a row is a;

• a. column

• b. Link

• c. router

• d. record

What are you doing, when populating a database?

• a. Removing a record

• b. Entering data in various fields for each record

• c. Setting up a primary key

• d. Deleting a column

A table structure includes all of the following except

• a. Datatype

• b. The data

• c. Rows

• d. Columns

What is a foreign key?

• 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 in one table that refers to the primary key in another table

9. Why use the description in the table structure?

• a. To provide color and texture

• b. To provide information about objects contained in the database

• c. To make it easier to open

• d. So that others can share what you created

Modifying a table structure means all of the following except

• a. Deleting Fields

• b. Adding Records

• c. Changing field properties

• d. Searching for information