BCIS 3610- EXAM 2 Question and answers correctly solved
4 views 0 purchase
Course
BCIS 3610
Institution
BCIS 3610
BCIS 3610- EXAM 2 Question and answers correctly solved
After entering data into a relational database, users can make all of the following basic data manipulations except:
a. selecting
b. joining
c. projecting
d. organizing - correct answers d. organizing
Why is cleansing data so that i...
BCIS 3610- EXAM 2 Question and
answers correctly solved
After entering data into a relational database, users can make all of the
following basic data manipulations except:
a. selecting
b. joining
c. projecting
d. organizing - correct answers d. organizing
Why is cleansing data so that it is accurate, complete, and relevant important
to an organization's success?
a. Information derived from the data is used in decision making
b. Power outages require careful recovery management
c. Security breaches can be avoided through data validation
d. Data cleansing prevents user data-entry errors - correct answers a.
Information derived from the data is used in decision making
"Data cleansing is the process of detecting and then correcting or deleting
incomplete, incorrect, inaccurate, or irrelevant records that reside in a
database. The goal of data cleansing is to improve the quality of the data used
in decision-making."
What is the term for the awareness and understanding that are required to
define relationships among raw facts by organizing and processing them? -
correct answers Knowledge
Which statement accurately describes a data governance team?
a. It develops policies for data security but not data accuracy, consistency, or
completeness
, b. It is most effective when it consists of a few senior members of the
information system organization
c. It defines processes for protecting data from cyberattacks, inadvertent
destruction, or theft
d. It enforces policies, standards, and procedures developed by the other
teams - correct answers c. It defines processes for protecting data from
cyberattacks, inadvertent destruction, or theft
A(n) [Blank] is a characteristic or a set of characteristics that uniquely identify
the record - correct answers Primary key
Which of the following statements is true of a database?
a. It provides an essential foundation for an organization's knowledge
management and artificial intelligence systems
b. It is a collection of unstructured data
c. It helps companies analyze information to identify new market opportunities
d. It is accessed only by an organization's database administrator and data
administrator - correct answers c. It helps companies analyze information to
identify new market opportunities
Which statement about maintaining accurate and complete data is true? -
correct answers Data cleansing may involve standardizing data
Mark creates a new relational database table that includes only five of the
seven columns in the existing products table. This action is known as ____. -
correct answers projecting
A key purpose of data normalization is to eliminate _____. - correct answers
data redundancy
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller flyhigher329. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
