Name:     ID: 
 
Email: 

1302 Chapter 5 quiz fall 08

True/False
Indicate whether the statement is true or false.
 

 1. 

An assembly language can contribute to organizational success by providing managers and decision makers with timely, accurate, and relevant information based on data.
 

 2. 

A database provides an essential foundation for an organization’s information and decision support system.
 

 3. 

A database, a DBMS, and the application programs that use the data make up the database environment.
 

 4. 

Attributes are usually selected to reflect the relevant characteristics of entities such as employees or customers.
 

 5. 

Data modeling usually involves understanding a specific business problem and analyzing the data and information needed to deliver a solution.
 

 6. 

ER diagrams help ensure that the relationships among the data entities in a database are correctly structured.
 

 7. 

The tables in relational databases organize data in rows and columns, simplifying data access and manipulation.
 

 8. 

Data anomalies often result in incorrect information, causing database users to be misinformed about actual conditions.
 

 9. 

Databases for personal computers are most often meant for multiple users.
 

 10. 

Large mainframe computer systems can do without multiuser DBMSs.
 

 11. 

All DBMSs share some common functions, such as providing a user view, physically storing and retrieving data in a database, allowing for database modification, manipulating data, and generating reports.
 

 12. 

A data dictionary should not include a description of data flows, the way records are organized, and the data-processing requirements.
 

 13. 

A DBMS can produce a wide variety of documents, reports, and other outputs that can help organizations achieve their goals.
 

 14. 

Database systems require a skilled project manager.
 

 15. 

Data warehouses allow managers to drill down to get more detail or roll up to take detailed data and generate aggregate or summary reports.
 

 16. 

A data model stores historical data that has been extracted from operational systems and external data sources.
 

 17. 

Data marts bring the data warehouse concept (online analysis of sales, inventory, and other vital business data that has been gathered from transaction processing systems) to small and medium-sized businesses and to departments within larger companies.
 

 18. 

Data marts are most useful for large groups who want to access general data.
 

 19. 

A data warehouse contains detailed information that can be used by an entire company.
 

 20. 

A standardized, uniform approach to database access means that all application programs use the same overall procedures to retrieve data and information.
 

 21. 

One of the primary disadvantages of a relational database is that it does not allow tables to be linked.
 

 22. 

Valuable data is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.
 

 23. 

A network administrator is expected to have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.
 

 24. 

Because distributed databases rely on telecommunications lines to transport data, access to data can be slow.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 25. 

A ____ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.
a.
flat file
c.
front-end application
b.
database management system
d.
data dictionary
 

 26. 

A ____ is a skilled and trained IS professional who directs all activities related to an organization’s database, including providing security from intruders.
a.
network administrator
c.
database administrator
b.
software engineer
d.
system administrator
 

 27. 

A byte is typically ____ bits.
a.
2
c.
6
b.
4
d.
8
 

 28. 

A ____ is typically a name, number, or combination of characters that describes an aspect of a business object
a.
field
c.
record
b.
character
d.
file
 

 29. 

A collection of related data fields is a(n) ____.
a.
record
c.
entity
b.
database
d.
character
 

 30. 

A collection of related records is a(n) ____.
a.
entity
c.
file
b.
attribute
d.
schema
 

 31. 

A(n) ____ is a generalized class of people, places, or things (objects) for which data is collected, stored, and maintained.
a.
data model
c.
relational model
b.
entity
d.
attribute
 

 32. 

A(n) ____ is a field or set of fields in a record that identifies the record.
a.
file
c.
record
b.
attribute
d.
key
 

 33. 

The ____ approach to data management is an approach whereby separate data files are created and stored for each application program.
a.
traditional
c.
object-oriented
b.
systems
d.
database
 

 34. 

The ____ approach to data management is an approach whereby a pool of related data is shared by multiple application programs.
a.
traditional
c.
object oriented
b.
systems
d.
database
 

 35. 

____ is a way of organizing data in which the logical database design is altered so that certain data entities are combined, summary totals are carried in the data records rather than calculated from elemental data, and some data attributes are repeated in more than one data entity to improve database performance.
a.
Data modeling
c.
Concurrency control
b.
Planned data redundancy
d.
Data mining
 

 36. 

____ diagrams use basic graphical symbols to show the organization of and relationships between data.
a.
Entity relationship
c.
System
b.
SQL
d.
Domain
 

 37. 

The ____ is a database model that describes data in which all data elements are placed in two-dimensional tables, called relations.
a.
domain model
c.
entity model
b.
query model
d.
relational model
 

 38. 

____ involves the manipulation of data to eliminate rows according to certain criteria.
a.
Data mining
c.
Projecting
b.
Selecting
d.
Joining
 

 39. 

____ involves eliminating columns in a table.
a.
Joining
c.
Projecting
b.
Selecting
d.
Data mining
 

 40. 

____ involves combining two or more tables.
a.
Data mining
c.
Projecting
b.
Selecting
d.
Joining
 

 41. 

A(n) ____ is a simple database program whose records have no relationship to one another.
a.
flat file
c.
data mart
b.
data dictionary
d.
attribute
 

 42. 

Because the DBMS is responsible for access to a database, one of the first steps in installing and using a large database involves telling the DBMS the logical and physical structure of the data and relationships among the data in the database for each user. This description is called a(n) ____.
a.
record
c.
schema
b.
relation
d.
data model
 

 43. 

A(n) ____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
a.
machine language
c.
assembly language
b.
procedural languages
d.
data definition language
 

 44. 

A(n) ____ is a detailed description of all data used in the database.
a.
data mart
c.
attribute
b.
data dictionary
d.
data warehouse
 

 45. 

____ is a method of dealing with a situation in which two or more people need to access the same record in a database at the same time.
a.
Data modeling
c.
Predictive analysis
b.
Concurrency control
d.
Query by Example
 

 46. 

The ____ is responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.
a.
systems administrator
c.
database administrator
b.
network administrator
d.
project manager
 

 47. 

A ____ is one that directly interacts with people or users.
a.
database application
c.
proprietary application
b.
front-end application
d.
back-end application
 

 48. 

A ____ interacts with other programs or applications; it only indirectly interacts with people or users.
a.
database application
c.
proprietary application
b.
front-end application
d.
back-end application
 

 49. 

A ____ is a database that holds business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers.
a.
data warehouse
c.
relation
b.
data mart
d.
data dictionary
 

 50. 

____ is one aspect of business intelligence and is limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations.
a.
Competitive intelligence
c.
Counterintelligence
b.
Data synchronization
d.
Paging
 

 51. 

The term ____ describes the steps an organization takes to protect information sought by “hostile” intelligence gatherers.
a.
predictive analysis
c.
data cleanup
b.
data synchronization
d.
counterintelligence
 

 52. 

A ____ holds a duplicate set of frequently used data.
a.
data mart
c.
replicated database
b.
relational database
d.
procedural database
 

 53. 

An object-oriented database uses a(n) ____ to provide a user interface and connections to other programs.
a.
object-oriented database management system
b.
Java
c.
Visual Basic
d.
object-relational database management system
 

 54. 

Retailers use ____ to upgrade occasional customers into frequent purchasers by predicting what products they will buy if offered an appropriate incentive.
a.
databases
c.
bots
b.
predictive analysis
d.
systems analysis
 



 
         Start Over