DATABASE CONCEPTS

A ............ is an organized collection of structured data.

• information

• file

• database

• DBMS

A relational database consists of a collection of ..............

• tables

• fields

• records

• keys

A row in a database.

• Record
• Field
• Entity
• Table

Raw facts which people gather is referred to as ...

• information

• data

• knowledge

• wisdom

We need database for ...

• accessing data and information .

• processing the data as needed.

• updating existing data.

• all of the above.

A single set of related data values is referred to as

• Data Value

• Field

• Record

• Table

What is used to uniquely identify each record in a table?

• Foreign key

• Field

• Data type

• primary key

What is a database?

• An application that allows you to carry out general book-keeping tasks.

• A file that stores and organises large amounts of related data.

• A file that stores your computer’s configuration details.

• A device used to store deleted files.

A field that is a primary key in the same table or another table. It is the method of recording relations in a relational database.

• foreign key
• surrogate key
• name
• key field

For the following two ENTITIES, which is the appropriate relationship:
RULER / COUNTRY

• One to One
• One to Many
• Many to Many