Ch. 6

Which of the following best describes a data dictionary?

A data dictionary is an automated or manual tool for storing and organizing information about the data maintained in a database.

Which of the following best describes a data manipulation language?

A data manipulation language is associated with a database management system that end users and programmers use to manipulate data in the database.

Which of the following best describes a data quality audit?

A data quality audit is a structured survey of the accuracy and level of completeness of the data in an information system.

What would an organization use to specify rules for​ sharing, disseminating,​ acquiring, standardizing,​ classifying, and inventorying​ information?

An information policy

would specify that only selected members of the payroll and human resources department would have the right to change sensitive employee data, such as an employee's salary and social security number, and that these departments are responsible for making sure that such employee data are accurate.

An information policy

What is the term for data sets with volumes so huge that they are beyond the ability of typical DBMS to​ capture, store, and​ analyze?

Big Data

What is a specific software for​ creating, storing,​ organizing, and accessing data from a​ database?

DBMS

Which of the following functions of an organization is responsible for information policy, as well as for data planning, data dictionary development, and monitoring data usage in the firm?

Data administration

Which of the following can be used to automatically enforce consistency among different sets of data?

Data cleansing

a type of intelligence gathering that uses statistical techniques to explore records in a data warehouse, hunting for hidden patterns and relationships that are undetectable in routine reports.

Data mining

According to​ Jack's explanation of the structure of relational database​ tables, which of the following statements about columns and rows is​ true?

Each row is a unique record for one of the items in the table and each column is an attribute of the item.

You've probably used __________ to find the best airfare on the Internet, get directions to a restaurant, do a search on Google, or connect with a friend on Facebook.

Hadoop

breaks a big data problem down into sub-problems, distributes them among up to thousands of inexpensive computer processing nodes, and then combines the result into a smaller data set that is easier to analyze.

Hadoop

involves the process of creating small, stable, yet flexible data structures from complex groups of data when designing a relational database.

Normalization

Why is a relational DBMS so powerful?

Relational database products are available as cloud computing services.

Which of the following is not a step a firm might take to make sure they have a high level of data quality?

Using in-memory computing

Data definition is

a DBMS capability that specifies the structure and content of the database

In a database, __________ is used to uniquely identify each record for retrieval or manipulation.

a key field

In a database, each row represents

a record

According to the information presented in this​ video, a database management system​ (DBMS) is a software program for​ creating, processing, and​ _____ a database.

administering

In a database, each column represents

an attribute or a field

As part of a​ DBMS, a(n)​ _________ documents information about a database

data dictionary

David creates a central database by extracting, transforming, and loading metadata from various internal and external sources of information. He plans to use this database for executing various functions such as intelligence gathering, strategic planning, and analysis. This central repository of information is referred to as a

data warehouse

Most larger corporations utilize a​ ______ to consolidate data from a business along with external data

data warehouse

According to the information presented in this​ video, a spreadsheet is great to manage information about one thing​ (e.g., items for​ sale), but a​ _____ is preferred to manage information about more than one thing​ (e.g., items for sale and suppliers of​ items).

database

The __________ functions of an organization are responsible for defining and maintaining a database. These functions are performed by a database design and management group.

database administration

The​ _________ actually works with the​ databases, creating relations between tables and implementing controls that would minimize data issues and provide security for the data

database administration

In this​ video, Jack describes how metadata​

describe characteristics of each field

Organizations perform data quality audits to

determine accuracy and level of completeness of data

In a relational database generalized categories represent​ a(n) __________, and each category has characteristics called​ ______________

entity; attributes

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information are specified by __________.

information policies

As Jack explains to​ Kate, a database is a collection of​ _____ records.

integrated

The most common type of database is a​

relational database

Online analytical processing (OLAP) is best defined as

the capability for manipulating and analyzing large volumes of data from multiple perspectives