MIS Ch. 6 Quiz

In a student​ database, a column called LastName would be an example of​ a(n)

attribute

A​ ________ is represented by a 0 or 1.

bit

A​ ________ in a database represents a single character such as a letter or number.

byte

Microsoft Azure SQL is an example of a​ _________________ database.

cloud

Which of the following involves searching for patterns and relationships among​ data?

data mining

The special organizational function whose responsibilities include the technical and operational aspects of managing​ data, including physical database design and​ maintenance, is called​ ________.

database administration

The most common use of​ non-relational database management systems is for managing​ ________.

extremely large data sets

Which of the following is NOT a function of a data​ warehouse? A. Organize and relate data B. Filter data C. Cleanse data D. Catalog data E. Obtain data

filter data

Relational tables need to be​ ______________ to help avoid duplicate data.

normalized

A(n) __________ key uniquely identifies a row or record in a table.

primary

In a student​ database, a row that describes the top​ student, including his or her​ LastName, FirstName, and​ StudentNumber, is an example of​ a(n) ______________.

record

Relational databases enforce​ ______________ integrity to​ ensure, for​ instance, that a teacher​ can't be assigned to a CLASS table unless the teacher already exists in the TEACHER table.

referential

_______________ databases are by far the most popular type of database on the market today.

relational

What is the first step in effectively managing data for a​ firm?

specify the information policy

The​ "3V's" used to characterize big data include​ volume, variety, and​ _______.

velocity

Which statement about big data is​ FALSE? A. Big data can be processed with traditional techniques. B. Big data data sets are at least a petabyte in size. C. Big data has a variety of data with structured data and​ free-form text and logs. D. Big data can consist of multimedia files like​ graphics, audio, and video. E. Big data is generated rapidly.

Big data can be processed with traditional techniques

Which of the following statements about Hadoop is​ FALSE? A. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers. B. Hadoop combines results into a smaller data set that is easier to analyze. C. Hadoop is an open source software framework. D. Hadoop breaks a big data problem down into​ sub-problems. E. Hadoop extracts data from multiple tables that have a relationship.

Hadoop extract data from multiple tables that have a relationship

The data​ _______________ language allows you to retrieve information from the database​ (i.e., using the​ SELECT, FROM, WHERE​ commands).

Manipulation

If you need a DBMS for large commercial use on a​ mainframe, which of the following is a viable​ option?

Microsoft SQL Server

Which tool enables users to view the same data in different ways using multiple​ dimensions?

OLAP

What is the most popular data manipulation language and method to​ "question" a​ database?

Structured Query Language

Which of the following does NOT need to be addressed in an​ organization's information​ policy? A. What the relationships inside the data are B. Who is responsible for updating and maintaining the information C. Procedures and accountabilities around managing data resources D. Which users and organizational units can share information E. Where information can be distributed

What are the relationships inside the data are

Which of the following is a popular way to describe relationships​ (i.e., one-to-one,​ one-to-many) in a relational​ database?

entity-relationship diagram

In a student​ database, a collection of related attributes such as​ LastName, FirstName, and​ Student# creates​ a(n) _______________.

entity

A method that allows complex business calculations to be performed on very large data sets in seconds is termed​ __________.

in-memory computing