Chapter 6: Quiz

Which statement about big data is​ FALSE?

Big data can be processed with traditional techniques.

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?

filter data

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 there is already a record for that teacher in the TEACHER table.

referential

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

relational

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 first step in effectively managing data for a​ firm?

Specify the information policy

What is the most prominent 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?

What the relationships inside the data are

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

attribute

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

Which of the following statements about Hadoop is​ FALSE?

Hadoop extracts data from multiple tables that have a relationship.

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

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

entity

Data​ ________ is important because it establishes an​ organization's rules for​ sharing, disseminating,​ acquiring, standardizing, and classifying data.

governance

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

manipulation

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

normalized

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

primary

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

velocity

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

​in-memory