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.