Ch. 1 Quiz

_______ exists when different versions of the same data appear in different places. • Structural dependence • Conceptual dependence • Poor data security • Data inconsistency

data inconsistency

Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently? • Data dictionary • Data integrity • Data query • Data redundancy

data redundancy

Corporations use only structured data - true - false

false

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. - False - True

false

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. - True - False

false

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. • False • True

false

A ____ is a character or group of characters that has a specific meaning. • file • record • database • field

field

A ______ is a collection of related records. • schema • column • file • field

file

Accurate, relevant, and timely information is the key to ______. - good decision making - data management - knowledge - understanding

good decision making

______ is the result of revealing the meaning of raw facts. • An encoded sample • Information • An encrypted bit • End-user data

information

_______ is the body of information and facts about a specific subject. - A database - Knowledge - Validation - A format

knowledge

_____ provide a description of the data characteristics and the set of relationships that link the data found within the database. • Metadata • Schemas • Queries • End-user data

metadata

A workgroup database is a(n) ______ database. - desktop -multiuser - single-user - distributed

multiuser

______ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed. - Database management - Performance tuning - Query access - Database design

performance tuning

End-user data is... - raw facts of interest to the end user - information about a specific subject - knowledge about the end users - accurate, relevant and timely information

raw facts of interest to the end user

A ______ is a logically connected set of one or more fields that describes a person, place, or thing. • record • column • file • database

record

Most data that can be encountered are best classified as _____. • semistructured • historical • unstructured • structured

semistructured

_______ are the result of formatting disorganized data in order to facilitate storage, use and generation of information. • Unstructured data • Obsolete data • Structured data • Raw data

structured data

Data is said to be verifiable if: • the data cannot be changed or manipulated. • the data always yields consistent results. • the data is obtained from trusted sources. • the data is stored in different places within the database.

the data always yields consistent results

Which of the following is true of spreadsheet applications? • They do not allow manipulation of data once entered. • They are a better alternative to databases. • They provide enhanced security and robust data sharing features. • They enhance the user's ability to understand the data.

they enhance the user's ability to understand the data

A data warehouse can store data derived from many sources. • False • True

true

One disadvantage of a database system over previous data management approaches is increased costs. - True - False

true

Structure is based on the type of processing to be performed on the data. • False • True

true

data exist in the format in which they were collected. • Structured • Historical • Semistructured • Unstructured

unstructured