CIS chapter 6 quiz
Microsoft's DBMS that includes built-in report generation and reporting is called ________.
Access
________ is the most popular NoSQL DBMS.
Hadoop
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.
The SQL ________ statement allows you to combine two different tables.
JOIN
An emerging non-relational database management system is called ________.
NoSQL
SQL stands for ________.
Structured Query Language
Another name for a database field is a(n) ________.
attribute
A ________ is the smallest component in the computer system data hierarchy.
bit
A ________ is a component in the computer system data hierarchy that represents an ASCII character like a letter, a number, or another symbol.
byte
A ________ is software that enables an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.
database management system (DBMS)
A ________ provides the link from one table to another table's primary key.
foreign key
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
Another term for a key field is a ________.
primary key
The field that uniquely identifies a row in a relational database table is called a ________.
primary key
Another term for a database row is a(n) ________.
record
Microsoft SQL Server is a ________ for large mainframes and midrange computers.
relational DBMS
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
Data cleansing, working to identify and fix incorrect data, is also called ________.
data scrubbing
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(n) ________ is the most popular method to model a database.
entity-relationship (ER) model
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