ACC 564 Quiz 4 – Strayer New
ACC 564 Week 9 Quiz 4 Chapters 4,
15, 16 and 17
Click On The
Link Below To Purchase
Instant Download
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:
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:
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:
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:
Page
Ref: 88
Objective: Learning Objective 1
Difficulty
: Easy
AACSB:
Analytic
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:
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:
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:
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:
Page
Ref: 89
Objective: Learning Objective 1
Difficulty
: Easy
AACSB:
Analytic
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:
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:
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:
Page
Ref: 90
Objective: Learning Objective 3
Difficulty
: Easy
Comments
Post a Comment