Database Basic Concepts

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

• information

• data

• knowledge

• wisdom

What gives meaning to these numbers and figures is ...

• information

• data

• knowledge

• wisdom

A .... is an organized pool of logically related data.

• wisdom

• database

• information system

• data

The interaction between people, algorithmic processes, data and technology is referred to as ...

• wisdom

• database

• information system

• data

We need database for ...

• accessing data and information .

• processing the data as needed.

• updating existing data.

• all of the above.

A transaction is a unit of work performed within a database management system against a database.

• false

• true

A transaction is a unit of work performed within a database management system against a database.

• false

• true

Transactions in a database environment have two main purposes:

• To provide reliable units of work that allow correct recovery from failures and keep a database consistent.

• To make it easier for the user using the database.

• To provide isolation between programs accessing a database concurrently.

Transaction types include ...

• complex, recursive, and logical transactions.

• simple, nested, and multi leveled transactions.

• simple, moderate, and complex transactions..

... ensures users can access data at the same time.

• Data consistency

• Data concurrency

• Data validation

• Data verification