CIT 15 Chapter 11

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table. A) Referential integrity B) Normalization C) Database consistency D) Record integrity

A) Referential integrity

________ databases are the most commonly used electronic databases. A) Relational B) Flat-file C) Multidimensional D) Object-oriented

A) Relational

A(n) ________ check determines whether a required field such as LastName was filled in. A) completeness B) range C) consistency D) alphabetic

A) completeness

A ________ is a collection of related data that can be stored, sorted, organized, and queried. A) database B) spreadsheet C) memo D) macro

A) database

You can set a ________, which is automatically displayed in a field unless the user enters something different. A) default value B) relation C) field type D) numeric check

A) default value

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize. A) Exporting B) Importing C) Enhancing D) Extracting

A) exporting

In a database, the term ________ is synonymous with a category of information. A) field B) record C) row D) table

A) field

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)

A) natural language processing (NLP) system

Big data analytics is usually associated with ________ services. A) office support B) data warehouse C) management information D) decision support

B) data warehouse

You would use a ________ in a database to temporarily display records of residents for the city of Boston. A) sieve B) filter C) validation rule D) field constraint

B) filter

Data ________ means that the data contained in a database is accurate and reliable. A) efficiency B) integrity C) redundancy D) consistency

B) integrity

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field. A) text B) long text C) short text D) object

B) long text

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

B) mining the data

A ________ check would be used in a field to restrict the fines for speeding violations so that they fall between $50 and $250. A) completeness B) range C) consistency D) numeric

B) range

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

B) redundancy

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations. A) Boolean algebra B) relational algebra C) primary keys D) foreign keys

B) relational algebra

________ 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

C) Artificial intelligence

________ is used to ensure that data is organized most efficiently in a database. A) Consistency checking B) Validation C) Normalization D) Range checking

C) Normalization

Which of the following is a likely primary key in a student information record? A) Last name B) Date of birth C) Student ID number D) First name

C) Student ID number

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

C) consistency

Data in a multidimensional database is organized in a ________ format. A) linear B) modular C) cube D) cellular

C) cube

Management information systems (MIS) provide reports called ________ reports, which show conditions that are unusual or need attention from users of the system. A) detail B) summary C) exception D) expert

C) exception

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

C) one-to-one

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

C) real-time

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

C) select query

Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data. A) enterprise B) structured C) unstructured D) multidimensional

C) unstructured

A data ________ is a large-scale collection of data that contains and organizes all of an organization's data in one place. A) mart B) chain C) warehouse D) storehouse

C) warehouse

Data ________ helps to ensure data integrity by maintaining information in only one place. A) flexibility B) redundancy C) mapping D) centralization

D) centralization

A(n) ________ is a way of retrieving information from one or more tables that defines a particular subset of data. A) validation rule B) field constraint C) enquiry D) query

D) query

In a database, a group of related records is referred to as a(n) ________. A) memo B) field C) object D) table

D) table

In Microsoft Access, when you have the field name FirstName display as First Name, you are changing what field property?

caption

A business intelligence system is form of business information system that is used primarily at the consumer level.

false

A knowledge-based system is an analysis tool that, using internal and external data, provides a view of a particular business situation for the purposes of decision making.

false

A street address field is an example of a field that should have a default value.

false

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

false

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

false

Detail forms are used to control how new data is entered into a database.

false

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

false

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

false

In an Access database, all field types include a field size property.

false

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

false

Primary keys must be numbers that already represent something (like a telephone number.)

false

Small slices of a data mart are called data warehouses.

false

Text is an example of unstructured data.

false

The acronym BLOB stands for Bidirectional Large Objects.

false

The information in a data mart spans an entire enterprise.

false

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

false

Categories of data are called ________.

fields

Which of the following types of databases would be adequate for simple tasks?

flat

Which field property dictates whether the completeness check will trigger an error?

required

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

true

A group of related records is called a table.

true

A table in Microsoft Word or a spreadsheet in Microsoft Excel, can be used as a flat database.

true

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

true

In an Access database, a filter is limited to extracting data from a single table.

true

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.

true

In large organizations, a database administrator is responsible for designing, constructing, and maintaining the company's databases.

true

Most databases can import electronic data from other software applications.

true

NoSQL databases are good for unstructured data.

true

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

true

When data is kept in one location, such as a database system, it is known as data centralization.

true