Filters
Question type

Study Flashcards

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.


A) correctness
B) range
C) consistency
D) numeric

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Siri, the personal assistant application on Apple's iPhone is an example of a ________.


A) natural language processing (NLP) system
B) decision support system (DSS)
C) management information system (MIS)
D) database management system (DBMS)

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

A ________ is a collection of related data that can be stored, sorted, organized, and queried.


A) database
B) document
C) memo
D) macro

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.


A) integrity
B) redundancy
C) completeness
D) normalization

E) C) and D)
F) A) and D)

Correct Answer

verifed

verified

Match each of the following terms to its definition:

Premises
data dictionary
data warehouse
batch processing
real-time processing
relational database
Responses
organizes data into various tables based on logical groupings
when a database is queried and updated as a transaction is taking place
defines the name, data type, and length of each field in a database
large-scale collection of data
transaction data that are processed all at once

Correct Answer

data dictionary
data warehouse
batch processing
real-time processing
relational database

In a transaction-processing system (TPS) , if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.


A) direct
B) batch
C) real-time
D) immediate

E) All of the above
F) A) and C)

Correct Answer

verifed

verified

Match the following data checks to their definition:

Premises
numeric
consistency
range
completeness
alphabetic
Responses
ensures data entered into the database fall within a certain set of values
confirms that only textual characters are entered into a field
confirms that only numbers are entered into a field
compares values in two or more fields to see whether the values are reasonable
ensures that all required fields have data entered into them

Correct Answer

numeric
consistency
range
completeness
alphabetic

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

A) True
B) False

Correct Answer

verifed

verified

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.


A) many-to-one
B) one-to-many
C) one-to-one
D) many-to-many

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

________ is the branch of computer science that attempts to create computers that think like humans.


A) Natural language processing
B) Expert systems
C) Artificial intelligence
D) Enterprise resource planning

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Data in a multidimensional database is organized in a ________ format.


A) linear
B) modular
C) cube
D) cellular

E) A) and B)
F) B) and D)

Correct Answer

verifed

verified

A ________ displays a subset of data from a table (or tables) based on the specified criteria.


A) table query
B) join query
C) select query
D) criteria query

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

To temporarily display records from a single table that match certain criteria, you would use a(n) ________.

Correct Answer

verifed

verified

A(n) ________ tries to replicate the decision-making processes of human experts to solve specific problems.

Correct Answer

verifed

verified

A database that allows data to be maintained in a single location provides data ________.

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

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

When using SQL, a(n) ________ query is used to extract data from two or more tables.

Correct Answer

verifed

verified

Small slices of a data mart are called data warehouses.

A) True
B) False

Correct Answer

verifed

verified

A database schema defines the name, data type, and length of each field in the database.

A) True
B) False

Correct Answer

verifed

verified

Showing 41 - 60 of 75

Related Exams

Show Answer