Filters
Question type

Study Flashcards

MMSDB creates, reads, updates, and deletes data in a database while controlling access and security.

Correct Answer

verifed

verified

False

Of the two primary tools available for retrieving information from a DBMS, the first is a _______ by example tool that helps users graphically design the answer to a question against a database.

Correct Answer

verifed

verified

The primary purpose of a data warehouse is to perform transactional processes.

Correct Answer

verifed

verified

Nestlé is one of the companies shown as an example of low-quality information causing problems for the company.Which of the following are some of the errors they found in the data or information?


A) They had 550,000 actual vendors, yet the information reports showed more than 9 million due to duplication and abbreviation inaccuracies.
B) Some of the vendor names were abbreviated, whereas others were not.
C) They had too many inaccuracies and duplications to be able to identify customer profitability.
D) All of these

Correct Answer

verifed

verified

Which of the following provides real-time information in response to requests?


A) Sales system
B) Transactional system
C) Real-time system
D) Salary system

Correct Answer

verifed

verified

Data mining is the process of analyzing data to extract information not offered by the raw _______ alone.

Correct Answer

verifed

verified

A data warehouse is a tool that helps in many ways, including implementing customer profiles, hurting business operations, and many times alienating competitors.

Correct Answer

verifed

verified

What are rules that enforce basic and fundamental information-based constraints?


A) Information integrity
B) Integrity constraint
C) Business-critical integrity constraint
D) Relational integrity constraint

Correct Answer

verifed

verified

What is the process of analyzing data to extract information not offered by the raw data alone?


A) Data integrity
B) Data mart analysis
C) Data mining
D) Data extraction

Correct Answer

verifed

verified

C

Which of the following encompasses all of the information contained within a single business process or unit of work, where its primary purpose is to support daily operational tasks?


A) Targeted information
B) Analytical information
C) Productive information
D) Transactional information

Correct Answer

verifed

verified

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Correct Answer

verifed

verified

Many firms complete data ___________ audits to determine the accuracy and completeness of their data.

Correct Answer

verifed

verified

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Correct Answer

verifed

verified

What type of keys do you need to use to create a relational database model?


A) Primary keys and secondary keys
B) Primary keys and foreign keys
C) Entity keys and attribute keys
D) Relational keys and DBMS keys

Correct Answer

verifed

verified

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?


A) Relational integrity constraint
B) Business-critical integrity constraint
C) Information-critical integrity constraint
D) None of these

Correct Answer

verifed

verified

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Correct Answer

verifed

verified

Which of the following is not an advantage of a data-driven website?


A) Development
B) Minimizing human error
C) Increasing update costs
D) More efficient

Correct Answer

verifed

verified

Organizational information comes at different levels and in different formats and granularities.

Correct Answer

verifed

verified

Which of the following occurs when the same data element has different values?


A) Data modeling issue
B) Data mining issue
C) Data governance issue
D) Data inconsistency issue

Correct Answer

verifed

verified

Which of the following statements is true regarding customer information?


A) Customer information can exist in several operational systems.
B) Customer information in each operational system could change.
C) Customer information in each operational system can be different.
D) All of these.

Correct Answer

verifed

verified

D

Showing 1 - 20 of 206

Related Exams

Show Answer