CHAPTER 5: SELF-ASSESSMENT TEST
Data management and modeling are key aspects of
organizing data and information.
1. A group of programs that manipulate
the database and provide an interface between the database and the user of the
database and other application programs is called a(n)_______________.
a.
GUI
b.
operating system
c.
DBMS
2. A(n) database
administrator is a skilled and trained IS professional who directs
all activities related to an organization’s database.
3. Data redundancy is a desirable
quality in a database. True or False?
Answer : False.
4. A(n) _________ is a field or set of
fields that uniquely identifies a database record.
a.
attribute
b.
data item
c.
key
d.
primary key
5. A(n) entity-relationship
diagram uses basic graphical symbols to show the organization
of and relationships between data.
6. What database model places data in
two-dimensional tables?
a.
relational
b.
network
c.
normalized
d.
hierarchical
A well-designed and well-managed database is an extremely
valuable tool in supporting decision making.
7. Joining
involves combining two or more database tables.
8. After data has been placed into a
relational database, users can make inquiries and analyze data. Basic data
manipulations include selecting, projecting, and optimizing. True or False?
Answer : False
9. Because the DBMS is responsible for
providing access to a database, one of the first steps in installing and using
a database involves telling the DBMS the logical and physical structure of the
data and relationships among the data in the database. This description of an
entire database is called a(n) schema.
10. The commands used to access and report
information from the database are part of the _______________.
a.
data definition language
b.
data manipulation language
c.
data normalization language
d.
schema
11. Access is a popular DBMS for _______________.
a.
personal computers
b.
graphics workstations
c.
mainframe computers
d.
supercomputers
12. A new trend in database management, known as
Database as a Service, places the responsibility of storing and managing a
database on a service provider. True or False?
Answer : True
The number and types of database applications will
continue to evolve and yield real business benefits.
13. A(n) data warehouse
holds business information from many sources in the enterprise, covering
all aspects of the company’s processes, products, and customers.
14. An information-analysis tool that involves the
automated discovery of patterns and relationships in a data warehouse is called
_______________.
a.
a data mart
b.
data mining
c.
predictive analysis
d.
business intelligence
15. Predictive analysis
allows users to predict the future based on database information from the past
and present.
Tidak ada komentar:
Posting Komentar