Chapter 6
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
show | Entity-relationship diagram
🗑
|
||||
Which of the following technologies would you use to analyze the social media data collected by a major online retailer: | show 🗑
|
||||
show | True
🗑
|
||||
show | True
🗑
|
||||
All of the following are technologies used to analyze and manage big data except: | show 🗑
|
||||
Multiple data marts are combined and streamlined to create a data warehouse. | show 🗑
|
||||
show | Surveying data definition and query files
🗑
|
||||
show | False
🗑
|
||||
show | True
🗑
|
||||
show | A data manipulation language
🗑
|
||||
In terms of data relationships, associations refers to: | show 🗑
|
||||
Every record in a file should contain at least one key field. | show 🗑
|
||||
show | Datasets with fewer than a billion records
🗑
|
||||
Which of the following features enables a DBMS to reduce data redundancy and inconsistency: | show 🗑
|
||||
The logical view of a database: | show 🗑
|
||||
A ________ is a characteristic or quality that describes a database entity. | show 🗑
|
||||
show | False
🗑
|
||||
Data cleansing not only corrects errors but also: | show 🗑
|
||||
show | Creates a subset consisting of columns in a table
🗑
|
||||
NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations. | show 🗑
|
||||
A database record is a grouping of characters into a word, a group of words, or a complete number. | show 🗑
|
||||
Legacy systems are used to populate and update data warehouses. | show 🗑
|
||||
show | Primary key
🗑
|
||||
show | Text mining
🗑
|
||||
Databases record information about general categories of information referred to as entities. | show 🗑
|
||||
High-speed analytic platforms use both relational and non-relational tools to analyze large datasets. | show 🗑
|
||||
An application that transfers information from an organization's internal database to a web server for delivery as part of a web page to the user is called middleware. | show 🗑
|
||||
show | A crow's foot topped by a short mark
🗑
|
||||
show | CGI
🗑
|
||||
Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-t-many relationships. | show 🗑
|
||||
The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI. | show 🗑
|
||||
show | Redundancy
🗑
|
||||
show | True
🗑
|
||||
Which of the following is not a DBMS for midrange computers: | show 🗑
|
||||
A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data? | show 🗑
|
||||
show | False
🗑
|
||||
A data warehouse is composed of: | show 🗑
|
||||
show | True
🗑
|
||||
_______ creates confusion that hampers the creation of information systems that integrate data from different sources. | show 🗑
|
||||
The join operation: | show 🗑
|
||||
Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent. | show 🗑
|
||||
The most prominent data manipulation language today is: | show 🗑
|
||||
A _______ organizes data in two-dimensional tables. | show 🗑
|
||||
show | Select, project, and join
🗑
|
||||
Which common database challenge is illustrated by a person receiving multiple copies of a catalog, each addressed to a slightly different variation of his or her name? | show 🗑
|
||||
In a table for customers, the information about a single customer would reside in a single: | show 🗑
|
||||
To perform multidemensional data analysis, you would use: | show 🗑
|
||||
show | Identifying sequences
🗑
|
||||
Data mining is a tool for allowing users to: | show 🗑
|
||||
show | OLAP
🗑
|
||||
show | The entity customer with the attribute purchase
🗑
|
||||
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: | show 🗑
|
||||
Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database. | show 🗑
|
||||
show | Program-data independence
🗑
|
||||
With in-memory computing, a computer's primary memory (RAM) is used for processing. | show 🗑
|
||||
show | Creates a subset consisting of all records in the file that meet stated criteria.
🗑
|
||||
show | False
🗑
|
||||
You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of: | show 🗑
|
||||
DBMSs typically include report-generating tools in order to: | show 🗑
|
||||
show | False
🗑
|
||||
show | Library card catalog
🗑
|
||||
The organization's rules for sharing, disseminating, acquiring, standardizing, classifying and inventorying information is called: | show 🗑
|
||||
show | True
🗑
|
||||
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and the security is the: | show 🗑
|
||||
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: | show 🗑
|
||||
A DBMS makes the: | show 🗑
|
||||
A field identified in a record as holding the unique identifier for that record is called the: | show 🗑
|
||||
When the same attribute in related data files has different values, this is called data: | show 🗑
|
||||
show | False
🗑
|
||||
show | True
🗑
|
||||
You can manipulate data on a web server by using a cgi script. | show 🗑
|
||||
show | Users to obtain online answers to ad-hoc questions rapidly.
🗑
|
||||
Microsoft SQL Server is a: | show 🗑
|
||||
A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases. | show 🗑
|
||||
The special organizational function whose responsibilities include physical database design and maintenance is called: | show 🗑
|
||||
You are creating a database to store temperature and wind data from national airport locations. | show 🗑
|
||||
show | Creating an inventory of the data elements
🗑
|
||||
show | True
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
scottcampbell