DBM Exam: Correctly Answered Questions
_____ is the duplication of data or the storing of the same data in more than one
place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy Right Ans - Data redundancy
Which of the following is not a problem associated with redundancy?
a. prevents orphan records
b. makes updating data more cumbersome and time-consuming
c. can lead to inconsistencies
d. results in more frequent data errors Right Ans - prevents orphan records
A(n) _____ is a person, place, object, event, or idea for which you want to store
and process data.
a. Attribute
b. Entity
c. relationship
d. flat file Right Ans - Entity
A(n) _____ is a characteristic or property of an entity.
a. Metadata
b. database
c. flat file
d. attribute Right Ans - attribute
A(n) _____ exists between two entities when each row in the first entity may
match many rows in the second entity, and each row in the second entity
matches only one row in the first entity.
a. Record
b. many-to-many relationship
c. one-to-many relationship
, d. attribute Right Ans - one-to-many relationship
A(n) _____ is a structure that contains data about many categories of
information as well as the relationships between those categories.
a. Table
b. data file
c. relational database
d. software stack Right Ans - relational database
Which of the following describes how to create a one-to-many relationship in
a database system?
a. Insert a new table between two existing tables.
b. Use a common field in the two tables to tie the related records from each
table together.
c. Create an entity-relationship (E-R) diagram.
d. Include multiple entries in a single field. Right Ans - Use a common field
in the two tables to tie the related records from each table together.
In a(n) _____, rectangles represent entities and display their attributes; lines
represent relationships between connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
c. spreadsheet
d. software stack Right Ans - entity-relationship (E-R) diagram
Which of the following defines a DBMS?
a. a collection of data that corresponds to one record
b. a file used to store data about a single entity
c. the person or group in charge of a database
d. a program through which users interact with the data stored in a database
Right Ans - a program through which users interact with the data stored in a
database
Which of the following describes database design?
_____ is the duplication of data or the storing of the same data in more than one
place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy Right Ans - Data redundancy
Which of the following is not a problem associated with redundancy?
a. prevents orphan records
b. makes updating data more cumbersome and time-consuming
c. can lead to inconsistencies
d. results in more frequent data errors Right Ans - prevents orphan records
A(n) _____ is a person, place, object, event, or idea for which you want to store
and process data.
a. Attribute
b. Entity
c. relationship
d. flat file Right Ans - Entity
A(n) _____ is a characteristic or property of an entity.
a. Metadata
b. database
c. flat file
d. attribute Right Ans - attribute
A(n) _____ exists between two entities when each row in the first entity may
match many rows in the second entity, and each row in the second entity
matches only one row in the first entity.
a. Record
b. many-to-many relationship
c. one-to-many relationship
, d. attribute Right Ans - one-to-many relationship
A(n) _____ is a structure that contains data about many categories of
information as well as the relationships between those categories.
a. Table
b. data file
c. relational database
d. software stack Right Ans - relational database
Which of the following describes how to create a one-to-many relationship in
a database system?
a. Insert a new table between two existing tables.
b. Use a common field in the two tables to tie the related records from each
table together.
c. Create an entity-relationship (E-R) diagram.
d. Include multiple entries in a single field. Right Ans - Use a common field
in the two tables to tie the related records from each table together.
In a(n) _____, rectangles represent entities and display their attributes; lines
represent relationships between connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
c. spreadsheet
d. software stack Right Ans - entity-relationship (E-R) diagram
Which of the following defines a DBMS?
a. a collection of data that corresponds to one record
b. a file used to store data about a single entity
c. the person or group in charge of a database
d. a program through which users interact with the data stored in a database
Right Ans - a program through which users interact with the data stored in a
database
Which of the following describes database design?
