Database Introduction

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

Some advantages of the database approach include all, but:

• Minimal data redundancy
• Program-data dependency
• Improved data consistency
• Improved data sharing

A database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

The following are functions of a DBMS except

• Creating database
• Processing data
• Creating and processing forms
• Administrating database

What is database?

• An
  collection of
  related table.
• An
  integrated
  collection of
  logically
  related table.
• An
  integrated
  collection of
  related table.
• An
  collection of
  logically
  related table.

A database does NOT consist of .........

• field
• table
• character
• report

Tables in database NOT

• known as folder
• consist a set of related records
• organized in rows and column
• contain fields and records

Records in database .....

• A group of related records in a
  database.
•  known as row
• contains data about a given
  person only
• known as column

The records of a table can be of ________ order.

• Any
• Same
• Sorted
• Constant