Filters
Question type

Study Flashcards

Normalization means that there are no data entry errors in a database.

Correct Answer

verifed

verified

A group of related records is called a table.

Correct Answer

verifed

verified

Data redundancy ensures that the data contained in the database is accurate and reliable.

Correct Answer

verifed

verified

When creating a data warehouse, ________ is is the process that extracts data from source databases, reformats the data, and stores them in the warehouse.

Correct Answer

verifed

verified

A(n) ________ provides a view of data fields to be filled in with appropriate labels to assist a user in entering data into the database.

Correct Answer

verifed

verified

Match each of the following terms to its definition:

Premises
2)natural language processing (NLP)
1)office support system (OSS)
4)decision support system (DSS)
5)enterprise resource planning (ERP) system
3)management information system (MIS)
Responses
assists employees in day-to-day tasks and communication
helps managers develop solutions for specific problems
communicates with computer systems using a natural spoken or written language
software system that integrates multiple system data sources and ties together the various processes of an organization
provides managers with timely and accurate information

Correct Answer

2)natural language processing (NLP)
1)office support system (OSS)
4)decision support system (DSS)
5)enterprise resource planning (ERP) system
3)management information system (MIS)

In a relational database, a(n) ________ relationship indicates that a record that appears only one time in a table, may appear multiple times in a related table.

Correct Answer

verifed

verified

In a database, another term for a table is a(n) ________.

Correct Answer

verifed

verified

A(n) ________ check determines whether a required field such as LastName was filled in.


A) completeness
B) range
C) consistency
D) alphabetic

Correct Answer

verifed

verified

Data staging consists of all of the following steps, EXCEPT ________.


A) transforming the data
B) mining the data
C) storing the data in a warehouse
D) extracting the data

Correct Answer

verifed

verified

Match each of the following terms to its definition:

Premises
2)expert system
5)data staging
4)artificial intelligence
1)data mining
3)data mart
Responses
process by which great amounts of data are analyzed and investigated
attempts to create computers that think like humans
includes transforming data to fit into a data warehouse
process that extracts data from source databases, reformats the data, and stores them in a warehouse
software that tries to replicate the decision making of human specialists

Correct Answer

2)expert system
5)data staging
4)artificial intelligence
1)data mining
3)data mart

________ data are information about how users of a company's website move through the web pages.

Correct Answer

verifed

verified

Data mining analyzes and investigates large amounts of data with the intention of discovering significant patterns or trends.

Correct Answer

verifed

verified

A filter is limited to extracting data from a single table.

Correct Answer

verifed

verified

A data dictionary is also referred to as a(n) ________.

Correct Answer

verifed

verified

database s...

View Answer

Showing 61 - 75 of 75

Related Exams

Show Answer