Concepts of Database Management, 10th ed. Module 1
Questions (100% Error-free answers)
Redundancy refers to the duplication of data, or the storing of the same data in more than one
place.
True or False correct answers ANSWER:
True
Redundancy makes changing data more cumbersome and time-consuming.
True or False correct answers ANSWER:
True
An entity is a person, place, event, item, or other transaction for which you want to store and
process data.
True or False correct answers ANSWER:
True
An employee's last name is an example of an attribute.
True or False correct answers ANSWER:
False
An attribute is known as a row in most databases.
True or False correct answers ANSWER:
False
A(n) _____ can store information about multiple types of entities and the relationships among
the entities.
a. flat file
b. attribute
c. relational database
d. spreadsheet correct answers ANSWER:
c. relational database
Which of the following is a visual way to represent and analyze a database?
a. entity-relationship (E-R) diagram
, b. algorithm
c. encryption diagram
d. metadata correct answers ANSWER:
a. entity-relationship (E-R) diagram
What do two tables use to link related records from each table?
a. a form
b. an orphan record
c. a unique value
d. a common field correct answers ANSWER:
d. a common field
In an organization, who is usually responsible for improving databases to provide efficient and
effective access to their information?
a. business owner
b. database administrator (DBA)
c. database supporter (DBS)
d. data-entry clerks correct answers ANSWER:
b. database administrator (DBA)
Microsoft Access is well-suited to which of the following cases?
a. A few trusted users work with the database at the same time.
b. The database is very large, containing dozens of tables and thousands of records.
c. Many users work with the database in separate geographical locations.
d. The database has strict security requirements because it is available on the Internet. correct
answers ANSWER:
a. A few trusted users work with the database at the same time.
Which of the following is a screen object used to maintain and view data from a database?
a. spreadsheet
Questions (100% Error-free answers)
Redundancy refers to the duplication of data, or the storing of the same data in more than one
place.
True or False correct answers ANSWER:
True
Redundancy makes changing data more cumbersome and time-consuming.
True or False correct answers ANSWER:
True
An entity is a person, place, event, item, or other transaction for which you want to store and
process data.
True or False correct answers ANSWER:
True
An employee's last name is an example of an attribute.
True or False correct answers ANSWER:
False
An attribute is known as a row in most databases.
True or False correct answers ANSWER:
False
A(n) _____ can store information about multiple types of entities and the relationships among
the entities.
a. flat file
b. attribute
c. relational database
d. spreadsheet correct answers ANSWER:
c. relational database
Which of the following is a visual way to represent and analyze a database?
a. entity-relationship (E-R) diagram
, b. algorithm
c. encryption diagram
d. metadata correct answers ANSWER:
a. entity-relationship (E-R) diagram
What do two tables use to link related records from each table?
a. a form
b. an orphan record
c. a unique value
d. a common field correct answers ANSWER:
d. a common field
In an organization, who is usually responsible for improving databases to provide efficient and
effective access to their information?
a. business owner
b. database administrator (DBA)
c. database supporter (DBS)
d. data-entry clerks correct answers ANSWER:
b. database administrator (DBA)
Microsoft Access is well-suited to which of the following cases?
a. A few trusted users work with the database at the same time.
b. The database is very large, containing dozens of tables and thousands of records.
c. Many users work with the database in separate geographical locations.
d. The database has strict security requirements because it is available on the Internet. correct
answers ANSWER:
a. A few trusted users work with the database at the same time.
Which of the following is a screen object used to maintain and view data from a database?
a. spreadsheet
