Topic 1

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than:

• 1 terabyte of data.

• 3 gigabytes of data.

• at least 100 petabytes of data.

• more than 7 billion exabytes of data.

Database management involves all of the following EXCEPT:

• collecting data.

• organizing data.

• design web pages.

• managing data.

A database is an organized collection of ________ related data.

• logically

• physically

• loosely

• badly

Legacy systems often contain data of ________ quality and are generally hosted on ________.

• poor; personal computers

• excellent; mainframes

• poor; mainframes

• excellent; workgroup computers

Program-data dependence is caused by:

• file descriptions being stored in each database application.

• data descriptions being stored on a server.

• data descriptions being written into programming code.

• data cohabiting with programs.

Because applications are often developed independently in file processing systems:

• the data is always non-redundant.

• unplanned duplicate data files are the rule rather than the exception.

• data can always be shared with others.

• there is a large volume of file I/O.

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

• entity.

• relationship.

• relation.

• association.

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

• enterprise view

• reporting document

• user view

• user snapshot

A graphical system used to capture the nature and relationships among data is called a(n):

• XML data model.

• hypertext graphic.

• relational database.

• data model.

Data that describe the properties of other data are:

• relationships.

• logical.

• physical.

• metadata.