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!
|
|
||||
|---|---|---|---|---|---|
| A schematic of the entire database that describes the relationships in a database is called an: | show 🗑
|
||||
| show | Hadoop
🗑
|
||||
| show | True
🗑
|
||||
| show | True
🗑
|
||||
| show | Cloud computing
🗑
|
||||
| show | False
🗑
|
||||
| show | Surveying data definition and query files
🗑
|
||||
| show | False
🗑
|
||||
| show | True
🗑
|
||||
| show | A data manipulation language
🗑
|
||||
| show | Occurrences linked to a single event
🗑
|
||||
| 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 🗑
|
||||
| show | False
🗑
|
||||
| show | True
🗑
|
||||
| A field identified in a table as holding the unique identifier of the table's records is called the: | show 🗑
|
||||
| ________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc. to discover patterns and relationships. | show 🗑
|
||||
| Databases record information about general categories of information referred to as entities. | show 🗑
|
||||
| show | True
🗑
|
||||
| show | True
🗑
|
||||
| show | A crow's foot topped by a short mark
🗑
|
||||
| In place of application server software to allow a web server to communicate with a back-end database, you can use: | show 🗑
|
||||
| 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
🗑
|
||||
| To analyze unstructured data, such as memos and legal cases, you would use text mining tools. | show 🗑
|
||||
| show | Microsoft Access
🗑
|
||||
| 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 🗑
|
||||
| DBMS have a data definition capability to specify the structure of the content of the database. | show 🗑
|
||||
| _______ creates confusion that hampers the creation of information systems that integrate data from different sources. | show 🗑
|
||||
| show | Combines relational tables to provide the user. . .
🗑
|
||||
| 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 🗑
|
||||
| In a relational database, the three basic operations used to develop useful sets of data are: | show 🗑
|
||||
| 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
🗑
|
||||
| show | Data scrubbing
🗑
|
||||
| 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
🗑
|
||||
| show | True
🗑
|
||||
| The select operation: | show 🗑
|
||||
| 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 🗑
|
||||
| show | Display data in an easier-to-read format
🗑
|
||||
| show | False
🗑
|
||||
| A _______ is an example of non-digital data storage that is comparable to a database. | show 🗑
|
||||
| show | Information policy
🗑
|
||||
| The logical and physical views of data are separated in a DBMS. | show 🗑
|
||||
| show | Data dictionary
🗑
|
||||
| show | Normalization
🗑
|
||||
| A DBMS makes the: | show 🗑
|
||||
| A field identified in a record as holding the unique identifier for that record is called the: | show 🗑
|
||||
| show | Inconsistency
🗑
|
||||
| show | False
🗑
|
||||
| The policies and processes for managing the integrity and security of data in a firm are referred to as data governance. | show 🗑
|
||||
| show | True
🗑
|
||||
| OLAP is a tool for enabling: | show 🗑
|
||||
| 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