MIS Chapter 6

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

A

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

A

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

A

Microsoft's most powerful DBMS is​ ________. A. SQL Server B. MySQL C. DB2 D. Oracle E. Excel

A

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

A

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

E

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

E

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

E

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

E

Software that allows an organization to manage and provide access to data is a​ ________. A. system network B. systems process C. word processor D. spreadsheet E. database management system​ (DBMS)

E

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

E

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

B

Amazon is one of the first to provide cloud computing relational databases. This effort is called​ ________. A. CloudDB B. Amazon Relational Database Service C. ConnectDB D. Amazon Cloud E. Amazon DBMS

B

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. byte B. field C. bit D. file E. record

B

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

B

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

B

_________ is a widely used open source DBMS. A. Word Star B. MySQL C. SQL Server D. Excel E. DB2

B

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

C

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

C

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

C

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

C

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

D

A​ ________ is a component in the computer system data hierarchy that represents an ASCII character. A. bit B. field C. record D. byte E. file

D