BCIS 3610 EXAM 2 FINAL PAPER PRACTICE SOLUTION COMPLETE ANSWER PACK

BCIS 3610 EXAM 2 FINAL PAPER PRACTICE
SOLUTION COMPLETE ANSWER PACK

●● An organization may require high-quality data to avoid fines and
penalties for non-conformance to regulatory requirements
Answer: True


●● A collection of attributes about a specific entity is a
Answer: Record


●● Which of the following is not a function of the database management
system
Answer: database data normalization and data cleansing


●● A database and a database management system are the same thing.
Answer: False


●● A collection of instructions and commands to define and describe
data and relationship in a specific database is a
Answer: database schema

, ●● The process of detecting and then correcting or deleting incomplete,
incorrect, inaccurate, or irrelevant records that reside in a database is
called
Answer: data cleansing


●● In the design of a database, it is not necessary to know how long the
data must be stored.
Answer: False


●● The use of primary keys and foreign keys make it impossible to
define relationships between the data in two tables of a relational
database. True or False?
Answer: False


●● The purpose of data normalization is to _______________.
Answer: eliminate data redundancies and ensure data dependencies
make sense


●● ____ properties of SQL databases help ensure the integrity of data in
the database.
Answer: ACID


●● Which of the following is not an advantage associated with database-
as-a-service (DaaS)?