Exam (elaborations)
Chapter 4 Relational Databases
- Course
- Institution
Chapter 4 Relational Databases Accounting Information Systems 12Th Ed by Marshall B. Romney - Test Bank
[Show more]
Seller
Follow
ExamsExpert
Reviews received
Content preview
Accounting Information Systems, 12e (Romney/Steinbart)Chapter 4 Relational Databases
1) Using a file-oriented approach to data and information, data is maintained in
A) a centralized database.
B) many interconnected files.
C) many separate files.
D) a decentralized database.
Answer: C
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic
2) In a well-structured relational database,
A) every table must be related to at least one other table.
B) every table must be related to all other tables.
C) one table must be related to at least one other table.
D) one table must be related to all other tables.
Answer: A
Page Ref: 96-98
Objective: Learning Objective 4
Difficulty : Moderate
AACSB: Reflective Thinking
3) File-oriented approaches create problems for organizations because of
A) multiple transaction files.
B) a lack of sophisticated file maintenance software.
C) multiple users.
D) multiple master files.
Answer: D
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Moderate
AACSB: Analytic
4) Which statement is true regarding file systems?
A) Transaction files are similar to ledgers in a manual AIS.
B) Multiple master files create problems with data consistency.
C) Transaction files are permanent.
D) Individual records are never deleted in a master file.
Answer: B
Page Ref: 88
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic
1
Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall
,5) The ________ acts as an interface between the database and the various application programs.
A) data warehouse
B) database administrator
C) database management system
D) database system
Answer: C
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
6) The combination of the database, the DBMS, and the application programs that access the database
through the DBMS is referred to as the
A) data warehouse.
B) database administrator.
C) database system.
D) database manager.
Answer: C
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
7) The person responsible for the database is the
A) data coordinator.
B) database administrator.
C) database manager.
D) database master.
Answer: B
Page Ref: 88
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
8) All of the following are benefits of the database approach except:
A) Data integration and sharing
B) Decentralized management of data
C) Minimal data redundancy
D) Cross-functional analysis and reporting
Answer: B
Page Ref: 89
Objective: Learning Objective 1
Difficulty : Easy
AACSB: Analytic
2
Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall
, 9) The physical view of a database system refers to
A) how a user or programmer conceptually organizes and understands the data.
B) how the DBMS accesses data for a certain application program.
C) how and where the data are physically arranged and stored.
D) how master files store data values used by more than one application program.
Answer: C
Page Ref: 90
Objective: Learning Objective 2
Difficulty : Moderate
AACSB: Analytic
10) The ________ handles the link between the way data are physically stored and each user's logical
view of that data.
A) data warehouse
B) data dictionary
C) database management (DBMS) software
D) schema
Answer: C
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
11) The logical structure of a database is described by the
A) data dictionary.
B) schema.
C) database management system.
D) internal level.
Answer: B
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
12) The schema that provides an organization-wide view of the entire database is known as the
A) external-level schema.
B) internal-level schema.
C) conceptual-level schema.
D) logical view of the database.
Answer: C
Page Ref: 90
Objective: Learning Objective 3
Difficulty : Easy
AACSB: Analytic
3
Copyright © 2012 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 ExamsExpert. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$5.48. 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