BMIS 311, Chapter 6 RAT Questions
_______ is the most popular NoSQL DBMS
Hadoop
______ is another way to facilitate big data analysis and remove bottlenecks normally found in a traditional database.
In-memory computing
A(n) ________ is an important resource for an organization to create, illustrating rules on how data is organized and who has access to what data
Information Policy
What makes a Blockchain system possible and attractive to business firms?
Its encryption and authentication processes make it highly secure for storing many kinds of data.
_______ use a more flexible data model and are designed for big data.
Non-relational database management systems
SQL stands for _______
Structured Query Language
Microsoft's DBMS that includes built-in report generation and reporting is called _______
access
Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a peer-to-peer network nearly instantaneously without a central authority?
blockchain
DBMS have a data________ capability that is used to specify the structure of the content of the database
definition
A ________ provides the link from one table to another table's primary key.
foreign key
The term data ________ is used to describe the policies and processes for managing the availability, usability, integrity, and security of the data employed in an enterprise
governance
Data is considered to be ________ when the same attribute has different values
inconsistent
A(n) ________ is an important resource for an organization to create, illustrating rules on how data is organized and who has access to what data
information policy
The formal process to remove data problems such as repeating groups is called _______
normalization
Although "Big Data" doesn't refer to a specific amount of data, it usually does involve _______
petabytes
The field that uniquely identifies a row in a relational database table is called a ______
primary key
To describe datasets with volumes so huge that they are beyond the ability of typical DBMS to capture, store, and analyze, the term __________ is used
Big Data
All of the following are types of information obtained from data mining EXCEPT _____ A. classification B. sequences C. Web beacons D. clustering E. associations
C
The corporate function that is responsible for defining and organizing the content of the database as well as database maintenance is _______
Database administration
A(n) ________ enables an organization to centrally manage and organize data.
Database management system
The sales, manufacturing, and inventory systems at a bicycle manufacturer use different codes to represent bicycle frame sizes. For example, in the sales system, a large bike frame is coded with "L", while the inventory system codes a large bike frame with "LG". This situation illustrates ______
data inconsistency
Data cleansing, working to identify and fix incorrect data, is also called ______
data scrubbing
A(n) ________ is a database that stores historic and current data for the use of decision makers in the organization
data warehouse
A(n) ________ is a collection of data organized to serve many applications efficiently.
database
A(n) ________ database makes it possible to store information across millions of machines in hundreds of data centers around the globe, with special time-keeping tools to synchronize the data and ensure the data are always consistent
distributed
A person, place, or thing which is stored in a database is called a(n) ________
entity
A record describes a(n) ________ which is a person, place, thing, or event on which we store and maintain information. Each characteristic or quality describing a particular________ is called a(n) _______
entity; entity; attribute
A ________ is a component in the computer system data hierarchy that includes content such as Student ID 100, Course IS 101, and Grade A
field
A ________ is a component in the computer system data hierarchy that consists of multiple records of the same type
file
The most popular type of database today for PCs as well as for larger computers and mainframes is ___________ database
the relational