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
