Introduction

Question 1

Flat Files

Answer 1

No internal hierarchy

Question 2

Heap Files

Answer 2

Unsorted set of records with unique IDs which allows them to be inserted or deleted using that ID.

Question 3

Index Files

Answer 3

Store a list of lookup field values from a data file along with the location in the data file of the corresponding record.

Question 4

Hashed Files

Answer 4

Use a hash function to decide where a record should be placed on a disk which allows for faster lookup without an index file.

Question 5

Data

Answer 5

Consists of raw facts

Question 6

Information

Answer 6

The result of processing raw data to reveal its meaning

Question 7

Knowledge

Answer 7

Body of information and data about a specific subject

Question 8

Data Management

Answer 8

Proper generation, storage, and retrieval of data.

Question 9

Database

Answer 9

Shared, integrated computer structure that stores a collection of end-user data and metadata

Question 10

End-user Data

Answer 10

Raw facts of interest to the end user

Question 11

Metadata

Answer 11

Data about data

Question 12

DBMS

Answer 12

Database Management System

Collection of programs that manage the database structure and controls access to the data

Question 13

Query

Answer 13

Specific request issued to DBMS

Question 14

Data Quality

Answer 14

Accuracy, validity, and timeliness of data

Question 15

Business Intelligence

Answer 15

Comprehensive approach to capture and process business data with the purpose of generating information to support business decision making.

Question 16

Two-dimensional Table Structure

Answer 16

Found in most databases. Process of decomposing data into its constituent parts, each part in its own table.

Question 17

Structural Dependence

Answer 17

Access to a file is dependent on its structure

Question 18

Data Dependence

Answer 18

Changing field characteristics impacts the ability to access the data

Question 19

Logical Data Format

Answer 19

How human being views data

Question 20

Physical Data Format

Answer 20

How the computer must work with the data

Question 21

Islands of Information

Answer 21

Same basic data stored in different locations

Each island has different versions of the data

Question 22

Data Integrity

Answer 22

Data is accurate and verifiable

Question 23

Data Anomalies

Answer 23

Not all required changes in the redundant data are made successfully

Question 24

Database System

Answer 24

Components that define and regulate the collection, storage, management, and use of data.