True |
Web mining is the discovery of useful patterns on the Web |
False |
A grouping of characters into a word, a group of words, or a complete number is called a record. |
True |
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 |
False |
Most back-end databases are able to interpret HTML commands |
True |
Hadoop can process large quantities of any type of data, including video and Twitter feeds |
False |
The two key services of Hadoop are HDFS and in-memory computing |
True |
A data warehouse may include information from legacy systems |
False |
A data warehouse is typically comprised of several smaller data marts |
True |
OLAP is a key tool of BI |
False |
OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior. |
True |
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 |
False |
Implementing a Web interface for a database requires changes to the database itself. |
True |
Common Gateway Interface is a specification for processing data on a Web server |
False |
In linking databases to the Web, the role of the application server is to host the DBMS |
True |
A firm’s information policy lays out who is responsible for updating and maintaining the information in a database system |
False |
The use of different terms for identifying data in a firm’s various information systems is an example of redundant data |
True |
Data cleansing is the same process as data scrubbing |
NoSQL databases |
MongoDB and SimpleDB are both examples of |
library card catalog |
An example of a pre-digital database is a: |
Identify the data needed to run the business |
What is the first step you should take in managing data for a firm? |
The entity CUSTOMER with the attribute ADDRESS |
Which of the following best illustrates the relationship between entities and attributes |
relational DBMS |
The type of logical database model that treats data as if they were stored in two-dimensional tables is the |
Relationships between entities |
What are the relationships that the relational database is named for |
attribute |
A characteristic or quality describing an entity is called a(n) |
five tables: for customers, employees, suppliers, parts, and sales |
The most basic business database is comprised of |
row |
In a table for customers, the information about a single customer would reside in a single |
tuple |
In a relational database, a record is also called a(n): |
primary key |
A field identified in a table as holding the unique identifier of the table’s records is called the |
key field |
A field identified in a record as holding the unique identifier for that record is called the: |
entity-relationship diagram |
A schematic of the entire database that describes the relationships in a database is called a(n) |
in two short marks |
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends: |
with a crows foot preceded by a short mark |
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends: |
intersection relation |
A table that links two tables that have a many-to-many relationship is often called a(n) |
normalization |
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: |
physical database available for different logical views |
A DBMS makes the |
presents data as they would be perceived by end users |
The logical view of a database |
Query wizard tool |
Which of the following is not a typical feature of DBMS |
DBMS for desktop PC systems |
access is a |
find new groupings within data |
In clustering, a data mining tool will |
popular open-source DBMS |
MySQL is a: |
discovery driven |
Data mining is more ________ than OLAP |
select, project, and join |
In a relational database, the three basic operations used to develop useful sets of data are |
creates a subset consisting of all records in the file that meet stated criteria |
The select operation |
SQL queries. |
All of the following are tools or technologies for extracting information from unstructured data sets except |
creates a subset consisting of columns in a table. |
The project operation |
Critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve |
Which of the following best describes the importance of creating an accurate data model for your business’s database |
data dictionary |
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the: |
one-to-one |
You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the |
SQL |
The most prominent data manipulation language today is |
display data in an easier-to-read format |
DBMS typically include report-generating tools in order to |
Structuring the database |
What is the purpose of a DBMS’s data definition function |
Non-relational DBMS |
Which of the following database types would be best suited for storing multimedia |
Analytic platforms |
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as: |
Data warehouse systems provide easy-to-use tools for managers to easily update data |
Which of the following statements about data warehouses is not true |
it typically focuses on a single subject area or line of business |
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: |
business intelligence |
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as |
OLAP. |
The tool that enables users to view the same data in different ways using multiple dimensions is: |
users to obtain online answers to ad hoc questions in a rapid amount of time. |
OLAP is a tool for enabling |
find hidden relationships in data |
Data mining is a tool for allowing users to |
occurrences linked to a single event |
In terms of the data relationships found by data mining, associations refers to |
events linked over time |
In terms of the data relationships found by data mining, sequences refers to |
web usage mining |
Which of the following would you use to find patterns in user interaction data recorded by Web servers? |
web structure mining |
Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites? |
database administration |
Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function |
text mining |
Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos. |
data redundancy |
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. |
data scrubbing |
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called |
referential integrity rules |
Relational database systems use ________ to ensure that relationships between coupled tables remain consistent. |
True |
A DBMS is special software for creating, storing, organizing, and accessing data from a database. |
True |
A physical view shows data as it is organized on the storage media |
True |
End users use a data manipulation language to manipulate data in the database |
open-source software framework designed for distributing data-processing over inexpensive computers. |
Hadoop is a(n): |
warehouse |
A data ________ stores current and historical data of potential interest to decision makers throughout the company. |
database server |
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS |
False |
An information policy specifies the procedures and rules for defining the structure and content of corporate databases. |
True |
Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource. |
data quality audit |
A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system. |
IS CH 6
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price