Exam (elaborations)
Modern Database Management 12Th Edition By Hoffer - Test Bank
- Course
- Institution
Modern Database Management 12Th Edition By Hoffer - Test Bank
[Show more]
Seller
Follow
evileye251
Reviews received
Content preview
,Modern Database Management, 11e (Hoffer et al.)Chapter 1 The Database Environment and Development Process
1) One application of data warehouses is:
A) shipping of information.
B) order processing.
C) decision support.
D) file updating.
Answer: C
Diff: 3 Page Ref: 4
Topic: Introduction
AACSB: Use of Information Technology
2) Older systems that often contain data of poor quality are called ________ systems.
A) controlled
B) legacy
C) database
D) mainframe
Answer: B
Diff: 3 Page Ref: 4
Topic: Introduction
AACSB: Use of Information Technology
Subtopic: Conversion Costs
3) A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
Answer: A
Diff: 1 Page Ref: 5
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology
4) Which of the following types of data can be stored in a database?
A) Voice
B) Letters
C) Numbers
D) All of the above
Answer: D
Diff: 1 Page Ref: 5
Topic: Basic Concepts and Definitions
AACSB: Analytic Skills, Use of Information Technology
Subtopic: Data
1
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
,5) Data processed in a way that increases a user's knowledge is:
A) text.
B) graphics
C) information.
D) hyperlink.
Answer: C
Diff: 1 Page Ref: 6
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology
Subtopic: Data Versus Information
6) Data that describe the properties of other data are:
A) relationships.
B) logical.
C) physical.
D) none of the above.
Answer: D
Diff: 2 Page Ref: 7
Topic: Basic Concepts and Definitions
AACSB: Use of Information Technology
Subtopic: Metadata
7) All of the following are properties of metadata EXCEPT:
A) data definitions.
B) processing logic.
C) rules or constraints.
D) data structures.
Answer: B
Diff: 2 Page Ref: 7
Topic: Basic Concepts and Definitions
AACSB: Analytic Skills, Use of Information Technology
Subtopic: Metadata
8) One disadvantage of file processing systems is:
A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints.
Answer: C
Diff: 2 Page Ref: 9
Topic: Traditional File Processing Systems
AACSB: Use of Information Technology
Subtopic: Disadvantages of File Processing Systems
2
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
, 9) Program-data dependence is caused by:
A) file descriptors being stored in each application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.
Answer: A
Diff: 2 Page Ref: 9
Topic: Disadvantages of File Processing Systems
AACSB: Use of Information Technology
Subtopic: Program-Data Dependence
10) Because applications are often developed independently in file processing systems:
A) the data is always non-redundant.
B) unplanned duplicate data files are the rule rather than the exception.
C) data can always be shared with others.
D) there is a large volume of file I/O.
Answer: B
Diff: 2 Page Ref: 9
Topic: Disadvantages of File Processing Systems
AACSB: Analytic Skills, Use of Information Technology
Subtopic: Duplication of Data
11) Organizations that utilize the file processing approach spend as much as ________ of their IS
development budget on maintenance.
A) 40 percent
B) 25 percent
C) 60 percent
D) 80 percent
Answer: D
Diff: 1 Page Ref: 9
Topic: Disadvantages of File Processing Systems
AACSB: Use of Information Technology
Subtopic: Excessive Program Maintenance
12) A graphical system used to capture the nature and relationships among data is called a(n):
A) logical data model.
B) hypertext graphic.
C) ERD.
D) data model.
Answer: D
Diff: 1 Page Ref: 10
Topic: The Database Approach
AACSB: Use of Information Technology
Subtopic: Data Models
3
Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller evileye251. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $26.63. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now