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