CIS 2200

Microsoft's DBMS that includes​ built-in report generation and reporting is called​ ________. A. Spreadsheets B. DB2 C. Access D. MySQL E. SQL Server

Access Microsoft Access is designed for small business​ DBMS, and includes​ built-in report​ generation, something SQL Server does not.

​A(n) ________ is a collection of data organized to serve many applications efficiently. A. email server B. word processor C. hard drive D. database E. information system

database A database is a collection of data organized to serve many applications efficiently.

What makes a Blockchain system possible and attractive to business​ firms? A. Blockchain systems always include remote maintenance and support capabilities. B. Its encryption and authentication processes make it highly secure for storing many kinds of data. C. Blockchain makes it easier for competitors to​ collude, ultimately to the detriment of consumers. D. Blockchain is easily implemented across larger enterprises. E. It is free open source software​ (OSS), which means that the copyright holder grants users rights and privileges.

Its encryption and authentication processes make it highly secure for storing many kinds of data. The simplicity and security that Blockchain offers has made it attractive for storing and securing financial​ transactions, supply chain​ transactions, medical records and other types of data.

The SQL​ ________ statement allows you to combine two different tables. A. COMBINE B. JOIN C. GROUP BY D. ORDER BY E. SELECT

JOIN The JOIN statement allows you to combine two more tables in a database.

An emerging​ non-relational database management system is called​ ________. A. Oracle B. XBRL C. an​ information-base D. a relational database E. NoSQL

NoSQL Companies are turning to​ NOSQL, a​ non-relational database management​ system, to manage extremely large datasets.

Another name for a database field is​ a(n) ________. A. attribute B. row C. database D. record E. tuple

attribute An attribute and a field are often used interchangeably.

A​ ________ is the smallest component in the computer system data hierarchy. A. bit B. record C. file D. byte E. field

bit A bit is the smallest component in the computer system data hierarchy.

A​ ________ is software that enables an organization to centralize​ data, manage them​ efficiently, and provide access to the stored data by application programs. A. system network B. systems process C. spreadsheet D. word processor E. database management system​ (DBMS)

database management system​ (DBMS) A database management system​ (DBMS) is software that permits an organization to centralize​ data, manage them​ efficiently, and provide access to the stored data by applications programs

A​ ________ is a component in the computer system data hierarchy that consists of multiple records of the same type. A. byte B. record C. field D. bit E. file

file A group of records of the same type is called a file.

A​ ________ provides the link from one table to another​ table's primary key. A. foreign key B. data key C. surrogate key D. primary key E. referential key

foreign key A foreign key provides the link between tables.

​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. A. database B. database approach C. data requirements D. information policy E. data model

information policy Every​ business, large and​ small, needs an information policy.

The formal process to remove data problems such as repeating groups is called​ ________. A. normalization B. data network C. primary key D. ER Diagramming E. DBMS

normalization Normalization is the process of reducing the unintended consequences of a database caused by​ updating, deleting, and modifying data.

The field that uniquely identifies a row in a relational database table is called a​ ________. A. data definition language B. column C. null value D. primary key E. foreign key

primary key Each table in a relational database has one field or group of fields that is its primary key or unique identifier.

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? A. Blockchain B. MySQL C. Cloud Spinner D. NoSQL E. DB2

Blockchain Blockchain is a distributed database technology that enables firms and organizations to create and verify transactions on a network nearly instantaneously without a central authority.

The process of detecting and correcting errors in a database is called​ ________. A. data mining B. data transmission C. data extraction D. data cleansing E. normalization

data cleansing Data​ cleansing, also known as data​ scrubbing, consists of activities for detecting and correcting data in a database that are​ incorrect, incomplete, improperly​ formatted, or redundant. Data cleansing not only corrects errors but also enforces consistency among different sets of data that originated in separate information systems. Specialized​ data-cleansing software is available to automatically survey data​ files, correct errors in the​ data, and integrate the data in a consistent​ company-wide format.

​A(n) ________ is a database that stores historic and current data for the use of decision makers in the organization. A. ​non-traditional database management system B. ​flat-file system C. ​in-memory database D. data warehouse E. transaction processing system

data warehouse A data warehouse is a database that stores current and historical data of potential interest to decision makers throughout the company.

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. A. NoSQL B. SQL C. relational D. distributed E. simple

distributed A distributed database is one that is stored in multiple physical locations.

A​ person, place, or thing which is stored in a database is called​ a(n) ________. A. attribute B. object C. bit D. entity E. file

entity An entity is a​ person, place,​ thing, or event about which we store and maintain data.

Microsoft SQL Server is a​ ________ for large mainframes and midrange computers. A. NoSQL B. SimpleDB C. MongoDB D. distributed database E. relational DBMS

relational DBMS Relational databases represent data as​ two-dimensional tables​ (called relations). Tables may be referred to as files. Each table contains data on an entity and its attributes.

​A(n) ________ is the most popular method to model a database. A. EM model B. model relationship​ (MR) C. normalization D. ​entity-relationship (ER) model E. enterprise model

​entity-relationship (ER) model An ER model shows relationships between database elements.