Chapter 11 TIA

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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

Artificial intelligence

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.

Exporting

A last name field is an example of a field that should have a default value.

F

A summary report generated by a MIS provides a list of the transactions that occurred during a specified time period.

F

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

F

Employees' last names would usually make an appropriate primary key field.

F

In a relational database, when two tables have a common field, the link between the tables is known as a hyperlink.

F

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

F

Small slices of a data mart are called data warehouses.

F

The information in a data mart spans an entire enterprise.

F

When using Access, the text of the Declaration of Independence would be stored in a short text field.

F

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

Referential integrity

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

T

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

T

A group of related records is called a table.

T

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

T

In an employee database, an employee's ID number, last name, first name, company position, address, city, state, and Zip Code make up a record.

T

Data ________ helps to ensure data integrity by maintaining information in only one place.

centralization

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

completeness

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

consistency

You can set a ________, which is automatically displayed in a field unless the user enters something different.

default value

Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system.

exception

In a database, the term ________ is synonymous with a category of information.

field

You would use a ________ in a database to temporarily display records of residents for the city of Boston.

filter

Data ________ means that the data contained in a database is accurate and reliable.

integrity

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

long text

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

mining the data

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

natural language processing (NLP) system

________ is used to ensure that data is organized most efficiently in a database.

normalization

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

one-to-one

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data.

query

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

select query

Which of the following is a likely primary key in a student information record?

student id number

In a database, a group of related records is referred to as a(n) ________.

table

Most databases can import electronic data from other software applications.

T

Real-time processing means that transactions are updated when they occur.

T

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

cube

Big data analytics is usually associated with ________ services.

data warehouse

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

database

A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250.

range

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.

real-time

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 ________.

redundancy

________ databases are the most commonly used electronic databases.

relational

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.

relational algebra

Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.

unstructured

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place.

warehouse


Kaugnay na mga set ng pag-aaral

Balancing Chemical Equations Assignment

View Set

Vascular disease and Atherosclerosis

View Set

Chapter 1- Introduction to Information Systems in Organizations

View Set

AP Macroeconomics Unit 2 Progress Check: MCQ

View Set

Chapter 6: Internal Control and Risk Management

View Set

Saunders Leadership/ Management/ Delegating/ Prioritizing Questions

View Set

Customer Information, Risk and Suitability, Product Information

View Set