Exam 7: Database Systems

Disaster recovery is part of a larger process called business ____ planning.

____ of data is a measure of how rapidly changes must be made to data.

A(n) ____________________ is a collection of data organized to meet users' needs.

A ____ database is a database that holds a duplicate set of frequently used data.

Transaction files often cause changes to master files.

A centralized database approach increases data redundancy.

Data ____________________ occurs when data is copied, stored, and used from different locations.

Fusion Tables, an online database by Google, utilizes a technology called data ____ that eliminates the problems inherent with working with different data types and formats.

Data that is inaccurate can be more dangerous to an organization or individual than no data at all.

The most common type of flat file format is called CSV for colon-separated values. _________________________

Every field has a field name and must also be assigned a fixed length.

A home budget software package is an example of a simple data management system. _________________________

Data integrity means that data stored in the database was accurate when it was entered, but may or may not be accurate now.

A(n) ____________________ is a generalized class of people, places, or things for which data is collected, stored, and maintained.

A ____ file database typically stores each record as a line of text, and uses commas, tabs, Or other indicators within the line to separate the fields within the record.

A(n) ____________________ field contains items such as yes or no.

Every field has a field name and a ____ length.

Shauna is the Database Administrator for an online store that sells cosmetics. They grew so fast that they ended up with seven different databases, and Shauna is now investigating how to set up a centralized database approach. -In the end, Shauna decided to go with a centralized database approach because of the better access to data and information. All of the following statements are true EXCEPT: ____.

No other record can have the same primary key.

Database ____ is the process of returning the database to its original, correct condition if the database has crashed or been corrupted.