Lessons review questions - Data Management Systems

Under the GPP Back-up approach, only one grandparent back-up file is maintained.

• True

• False

Which of the following are traditional problems encountered with the flat-file approach (check those that apply)

• Data currency

• Data updating

• Task-data dependency

• Data storage

Flat files are usually owned by its user and can be shared with others

• True

• False

The portion of the entire database the is visible to the users.

• Conceptual view

• Internal view

• Physical view

• User view

The programming language used to enable queries in a database

• Standard query language

• Data query language

• Data manipulation language

• Data definition language

A database environment eliminates the data redundancy that is present in a flat-file environment.

• True

• False

A primary person in the organization that is responsible in managing database access rights.

The manner at which records are physically arranged in a storage device, which can either be sequential or random.

Which of the following database models presents data in a tree format?

• Hierarchical model

• Network model

• Relational model

Which of the following are risk related to data management systems under the flat-file approach(check those that apply).

• Unauthorized access

• Data loss

• Malicious programs

• Hacking attacks