Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

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!  

Question
Answer
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.

 
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
Created by: scottcampbell