DSS Review Questions with verified
answers (passed)
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 answer ✔✔c
which of the following statements is correct?
a. in a flat-file environment, data is partitioned into several disjointed systems,
lists, and files
b. user data cannot be combined and shared among authorized users
c. database users should each work on their own copy of the database
d. controlling redundancy is easier in a flat file than in a database - correct answer
✔✔a
how are entities represented in a relational database?
a. each entity is stored as a row.
b. each entity is stored as an attribute
c. each entity s stored as a table
d. each entity is stored as a column - correct answer ✔✔c
, 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 answer ✔✔d
what is the term for a collection of data organized in a manner that allows access,
retrieval, and use of the data?
a. database
b. entity
c. code
d. flat file - correct answer ✔✔a
which of the following is a reason to store business data in a database rather than
a spreadsheet?
a. spreadsheets have limited text-formatting features
b. spreadsheets cannot be backed up
c. spreadsheets have limited data sharing and security features
d. spreadsheets have strict rules about data consistency - correct answer ✔✔c
which of the following fields would be the best candidate for a primary key field in
a table of employee data?
a. LastName
b. EmployeeID
c. Email
answers (passed)
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 answer ✔✔c
which of the following statements is correct?
a. in a flat-file environment, data is partitioned into several disjointed systems,
lists, and files
b. user data cannot be combined and shared among authorized users
c. database users should each work on their own copy of the database
d. controlling redundancy is easier in a flat file than in a database - correct answer
✔✔a
how are entities represented in a relational database?
a. each entity is stored as a row.
b. each entity is stored as an attribute
c. each entity s stored as a table
d. each entity is stored as a column - correct answer ✔✔c
, 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 answer ✔✔d
what is the term for a collection of data organized in a manner that allows access,
retrieval, and use of the data?
a. database
b. entity
c. code
d. flat file - correct answer ✔✔a
which of the following is a reason to store business data in a database rather than
a spreadsheet?
a. spreadsheets have limited text-formatting features
b. spreadsheets cannot be backed up
c. spreadsheets have limited data sharing and security features
d. spreadsheets have strict rules about data consistency - correct answer ✔✔c
which of the following fields would be the best candidate for a primary key field in
a table of employee data?
a. LastName
b. EmployeeID
c. Email
