MIS Chapter 6 - Foundations of Business

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

A. Database

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

A. NoSQL

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

A. Relational DBMS

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

A. entity-relationship (ER) model

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

A. foreign key

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

E. 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. A. ORDER BY B. GROUP BY C. SELECT D.COMBINE E.JOIN

E. JOIN

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

E. Normalization

Although​ "Big Data" does not refer to a specific amount of​ data, it usually does involve​ ________. A. bits B. bytes C. megabytes D. gigabytes E. petabytes

E. petabytes

________ is the most popular NoSQL DBMS. A. SQL Server B. Hadoop C. MySQL D. ID2 E. Paradox

B. Hadoop

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

B. attribute

Data​ cleansing, working to identify and fix incorrect​ data, is also called​ ________. A. data vacuum B. data scrubbing C. data chop D. ER diagramming E. normalization

B. data scrubbing

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

C. Access

A​ ________ is a component in the computer system data hierarchy that includes content such as Student ID​ 100, Course IS​ 101, and Grade A. A. bit B. record C. field D. byte E.file

C. Field

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

C. File

SQL stands for​ ________. A. Structured Question Language B. Structured Questioning Language C. Structured Query Language D. Special Question Language E. Streamlined Question Language

C. Structured Query Language

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

C. distributed

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

D. Bit

Which of the following is a distributed database technology that enables firms and organizations to create and verify transactions on a network nearly instantaneously without a central​ authority? A. MySQL B. DB2 C. Cloud Spinner D. Blockchain E. NoSQL

D. Blockchain

A​ ________ is a component in the computer system data hierarchy that represents an ASCII character like a​ letter, a​ number, or another symbol. A. record B. file C. field D. byte E. bit

D. Byte

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

D. database management system​ (DBMS)

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

D. information policy

Another term for a key field is a​ ________. A. surrogate key B. foreign key C. null key D. primary key

D. primary key

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

D. primary key

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

D. record