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