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