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