1) _____ is used to reveal the meaning of data.
A) Raw facts
B) Knowledge
C) Formatting
D) Information
2) Accurate, relevant, and timely information is the key to _____.
A) data management
B) good decision making
C) knowledge
D) understanding
3) _____ is the body of information and facts about a specific subject.
A) Data
B) Information
C) Knowledge
D) A database
4) End-user data is ____.
A) raw facts about the end-user
B) raw facts of interest to the end-user
C) data about data
D) accurate, relevant and timely information
5) ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
A) Queries
B) End-user data
C) Metadata
6) The _____ serve(s) as the intermediary between the user and the database.
A) DBMS
B) metadata
C) end-user data
D) programming language
7) The database structure in a DBMS is stored as a _______.
A) file
B) collection of files
C) set of key/value pairs
D) collection of queries
8) A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.
A) query
B) operating system
C) database management system
D) application program
9) _______ exists when different versions of the same data appear in different places.
A) Data inconsistency
B) Data consistency
C) Better data integration
D) Improved decision making
10) The response of the DBMS to a query is the _____.
A) ad hoc query
B) ad hoc response
C) query result set
D) integrated view of the data
11) A(n) _______ database is designed to support a company's day-today operations.
A) desktop
B) workgroup
C) enterprise
D) transactional
12) A(n) _______ database is used by an organization and supports many users across many departments.
13) A(n) ________ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
14) A ______ database supports data distributed across several different sites.
A) single-user
B) multiuser
C) centralized
D) distributed
15) A workgroup database is a(n) _____ database.
16) A desktop database is a ______ database.
C) workgroup
17) Most decision-support data are based on historical data obtained from _____.
A) operational databases
B) data warehouses
C) enterprise databases
D) workgroup databases
18) The _____ structure is quite different from that of an operational or transactional database.
A) data warehouse
B) workgroup database
C) enterprise database
D) distributed database
19) _____ data exist in the format in which they were collected.
A) Structured
B) Semistructured
C) Unstructured
D) Historical
20) _________ data exist in a format that does not lend itself to processing that yields information.
21) _______ data are the result of formatting to facilitate storage, use and generation of information.
22) Most data you encounter is best classified as _____.
A) structured
B) semistructured
C) unstructured
D) historical
23) Which of the following is an example of structured data?
A) A Web page
B) An e-mail
C) A memo
D) A spreadsheet
24) XML data is ______.
B) multistructured
D) semistructured
25) The organization of the data within the folders in a manual file system was determined by _______.
A) the date of creation
B) its expected use
C) the title of the documents in the folder
D) the data processing specialist
26) A ______ is a logically connected set of one or more fields that describes a person, place, or thing.
A) database
B) column
C) record
D) file
27) A ______ is a collection of related records.
B) field
C) column
28) A _____ is a character or group of characters that has a specific meaning.
29) The phrase ______ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
A) database management system
B) database management
C) management system
D) database system
30) _______ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
A) Performance tuning
B) Database design
C) Query access
D) Database management
