Chapter 6 Flashcards
Web mining is the discovery of useful patterns on the Web.
true
A grouping of characters into a word, a group of words, or a complete number is called a record
False
Every record in a file should contain at least one key field
True
Both Oracle and Microsoft Access use SQL to retrieve information from the database.
True
DBMS simplify how end users work with databases by separating the logical and physical views of the data
True
Most back-end databases are able to interpret HTML commands
False
Hadoop can process large quantities of any type of data, including video and Twitter feeds.
True
The two key services of Hadoop are HDFS and in-memory computing
False
A data warehouse may include information from legacy systems
True
A data warehouse is typically compromised of several smaller data marts
False
OLAP is a key tool of BI
True
OLAP is used to find hidden patterns and relationships in large databases, and infer rules for these to infer future behavior
False
A foreign key is a field that links to a separate table.
True
In-memory computing relies on a computer’s main memory for storing data
True
Implementing a Web interface for a database requires changes to the database itself
False
Common Gateway Interface is a specification for processing data on a Web server.
True
In linking databases to the Web, the role of the application sever is to host the DBMS.
False
A firm’s information policy lays out who is responsible for updating and maintaining the information in a database system
True
The use of different terms for identifying data in a firm’s various information systems is an example of redundant data.
False
Data cleansing is the same process as data scrubbing
True
MongoDB and SimpleDB are both examples of:
A) open-source databases
B) SQL databases
C) NoSQL databases
D) Cloud databases
C
An example of a pre-digital database is a:
A) library’s card-catalog
B) cash register receipt
C) doctor’s office invoice
D) list of sales totals on a spreadsheet
A
What is the first step you should take in managing data for a firm?
A) identify the data needed to run the business
B) cleanse the data before importing it to any database
C) normalize the data before importing to a database
D) audit your data quality
A
Which of the following best illustrates the relationship between entities and attributes?
A) the entity CUSTOMER with the attribute PRODUCT
B) the entity CUSTOMER with the attribute ADDRESS
C) the entity PRODUCT with the attribute PURCHASE
D) the entity PRODUCT with the attribute CUSTOMER
B
The type of logical database model that treats data as if they were stored in two-dimensional tables is the:
A) two-tiered DBMS
B) pre-digital DBMS
C) relational DBMS
D) hierarchical DBMS
C
What are the relationships that are relational database is named for?
A) relationships between rows and columns
B) relationships between entities
C) relationships between fields and records
D) relationships between databases
B
A characteristics or quality describing an entity is called a(n):
A) field
B) tuple
C) key field
D) attribute
D
The most basic business database is comprised of:
A) three tables: for suppliers, parts, and sales
B) four tables: for customers, suppliers, parts, and sales
C) four tables: for customers, suppliers, sales, and employees
D) five tables: for customers, employees, suppliers, parts, and sales
D
In a table for customers, the information about a single customer would reside in a single:
A) field
B) row
C) column
D) table
B
In a relational database, a record is also called a(n):
A) tuple
B) row
C) entity
D) field
A
