Web mining is the discovery of useful patterns on the Web.
answer
Answer: TRUE
Diff: 1 Page Ref: 203
So, contrast this with text mining and data mining.
question
A grouping of characters into a word, a group of words, or a complete number is called a record.
answer
Answer: FALSE
A grouping of fields is a record. (The phrases used in the question are nonsensical.)
question
Every record in a file should contain at least one key field.
answer
Answer: TRUE
Diff: 1 Page Ref: 188
question
Both Oracle and Microsoft Access use SQL to retrieve information from the database.
answer
Answer: TRUE
Diff: 2 Page Ref: 194-195
How is SQL pronounced? (Sequel)
What does it stand for? (structured query language)
question
DBMS simplify how end users work with databases by separating the logical and physical views of the data.
answer
Answer: TRUE
Physical view of data refers to where on the hard drive the different pieces of data are placed.
Logical view refers to the way in which we think about data - in the form of tables with columns for each field and a row for each record.
question
Most back-end databases are able to interpret HTML commands.
answer
Answer: FALSE
Diff: 1 Page Ref: 206
Front-end refers to those parts of the system which are closer to the user - the user interface in particular.
Back-end refers to files in which the organized information is stored.
question
Hadoop can process large quantities of any type of data, including video and Twitter feeds.
answer
Answer: TRUE
Diff: 2 Page Ref: 199
Hadoop can handle both relational and non-relational data, including text, video etc:
question
A data warehouse may include information from legacy systems.
answer
Answer: TRUE
Diff: 2 Page Ref: 199
Recall data warehouses include historical data; historical data may reside in legacy systems. (What is a legacy system?).
question
A data warehouse is typically comprised of several smaller data marts.
answer
Answer: FALSE
Diff: 2 Page Ref: 199
Data warehouse includes historic and current data from several databases.
Data mart is a subset of the data warehouse, created to try and answer specific questions.
question
OLAP is used to find hidden patterns and relationships in large databases, and infer rules from these to infer future behavior.
answer
Answer: FALSE
Data mining is used to find hidden patterns and relationships.
question
A foreign key in a table of the database is a field that links to the primary key of another table.
answer
Answer: TRUE
Diff: 2 Page Ref: 189
question
In-memory computing relies on a computer's main memory (RAM) for storing data.
answer
Answer: TRUE
Diff: 3 Page Ref: 200
Usually in-memory computing needs lots more of RAM than those systems that do not do in-memory computing. In-memory computing is used to speed up processing of data.
question
A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.
answer
Answer: TRUE
Diff: 1 Page Ref: 207
What else does the information policy include? Look it up.
question
The use of different terms for identifying data in a firm's various information systems is an example of redundant data.
answer
Answer: FALSE
Diff: 2 Page Ref: 208-209
question
Data cleansing is the same process as data scrubbing.
answer
Answer: TRUE
Diff: 2 Page Ref: 208
This is done when creating a data warehouse. Data warehouses contain historic data. Historic data over 10 or 15 years may have inconsistencies. For instance, in some databases my name may have been entered as Chino, and in others as Srinivasan. When you combine the two databases as part of creating the data warehouse, the system has no way of knowing that Chino is the same as Srinivasan. So, while creating the data warehouse, you have to go through a process of data cleansing - that is detecting such inconsistencies (and other kinds of inconsistencies) and rectifying them.
question
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
answer
Answer: A
question
The type of logical database model that treats data as if they were stored in two-dimensional tables is the:
A) two-tiered DBMS. (I don't think there is any such thing)
B) pre-digital DBMS. (I don't think there is any such thing)
C) relational DBMS.
D) hierarchical DBMS. (these were used in earlier generations of databases; they are good for speedy retrieval of data if you know what you are looking for exactly; they are not as flexible as relational databases.)
answer
Answer: C
Diff: 2 Page Ref: 188
question
In a table for customers, the information about a single customer would reside in a single:
A) field.
B) row.
C) column.
D) table.
answer
Answer: B
Diff: 2 Page Ref: 188
AACSB: Application of knowledge
CASE: Comprehension
Learning Objective: 1 - How does a relational database organize data?
question
A field identified in a table as holding the unique identifier of the table's records is called the:
A) primary key.
B) key field.
C) primary field. (meaningless phrase)
D) foreign key. (is the primary key in a different table)
answer
Answer: A
question
A field identified in a record as holding the unique identifier for that record is called the:
A) primary key.
B) key field.
C) primary field.
D) foreign key.
answer
Answer: B
NOTE: I don't like the distinction that the book has made between primary key and key field - it is subtle and can confuse people.
I need you to know what a PRIMARY KEY is. Please read the book to get a clear idea.
question
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
A) normalization.
B) data scrubbing.
C) data cleansing.
D) data administration.
answer
Answer: A
I need you to know that normalization is not easy. Users will not do it; database designers do it. If it is not done correctly, then the operation of the database will be clunky. It is an important step.
question
A DBMS makes the:
A) physical database available for different logical views.
B) logical database available for different analytical views.
C) physical database available for different relational views.
D) relational database available for different physical views
answer
Answer: A
Read the book and understand difference between physical and logical views of a database.
question
Which of the following is not a typical feature of DBMS?
A) Data manipulation language
B) Report generation tools
C) Data dictionary
D) Query wizard tool (there is no such thing)
answer
Answer: D
Food for thought: Does a DBMS have other features?
question
In clustering, a data mining tool will:
A) find new groupings within data.
B) find related predictions from existing values.
C) find several events grouped by time.
D) find new associations.
answer
Answer: A
Diff: 2 Page Ref: 202
question
MySQL is a:
A) DBMS for small handheld computing devices.
B) popular open-source DBMS.
C) mainframe relational DBMS.
D) DBMS for desktop systems.
answer
Answer: B
Diff: 2 Page Ref: 193
question
Data mining is more ________ than OLAP.
A) data focused
B) multidimensional
C) query oriented
D) discovery driven
answer
Answer: D
question
All of the following are tools or technologies for extracting information from unstructured data sets except:
A) sentiment analysis software.
B) SQL queries.
C) Hadoop.
D) Non-relational DBMS.
answer
Answer: B
The key word here is 'unstructured'. SQL works only with structured data.
question
The most prominent data manipulation language today is:
A) Access. (this is a DBMS, not a language)
B) DB2. (this is a DBMS, not a language)
C) SQL.
D) Crystal Reports. (generates reports, does not manipulate data)
answer
Answer: C
Diff: 1 Page Ref: 194
question
Which of the following statements about data warehouses is not true?
A) They store supply data to be used across the enterprise for management analysis and decision making.
B) Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities.
C) They may include data from Web site transactions.
D) Data warehouse systems provide easy-to-use tools for managers to easily update data.
answer
Answer: D
Diff: 2 Page Ref: 199
Key word is 'update', which means change (edit) data or add data. Managers/users should not add or change data in a data warehouse, so no 'easy' tools are provided for that for the user.
question
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:
A) it typically focuses on a single subject area or line of business.
B) all the information is historical.
C) it uses a Web interface.
D) all of the information belongs to a single company.
answer
Answer: A
I don't like the wording on this question. A data mart is a subset of a data warehouse. Usually, a data warehouse is created, and from that a subset focused on a single subject area is taken to create that subset. It would be unusual to create a datamart without creating the data warehouse first.
The reason I am leaving this question is that I would like you to know that a data mart focuses on a single subject area or line of business.
question
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:
A) DSS. (to support making semi-structured decisions)
B) business intelligence.
C) OLAP. (to do multi-dimensional analysi)
D) data mining.(to explore for patterns and relationships in data)
answer
Answer: B
Diff: 2 Page Ref: 198
question
The tool that enables users to view the same data in different ways using multiple dimensions is:
A) Hadoop.
B) SQL.
C) OLAP.
D) data mining.
answer
Answer: C
Diff: 2 Page Ref: 201
question
OLAP is a tool for enabling:
A) users to obtain online answers to ad hoc questions rapidly.
B) users to view both logical and physical views of data.
C) programmers to quickly diagram data relationships.
D) programmers to normalize data.
answer
Answer: A
Diff: 2 Page Ref: 201
question
Data mining is a tool for allowing users to:
A) quickly compare transaction data gathered over many years.
B) find hidden relationships in data.
C) obtain online answers to ad hoc questions in a rapid amount of time.
D) summarize massive amounts of data into much smaller, traditional reports.
answer
Answer: B
Diff: 2 Page Ref: 202
question
In terms of the data relationships found by data mining, sequences refers to:
A) events linked over time.
B) patterns that describe a group to which an item belongs.
C) occurrences linked to a single event.
D) undiscovered groupings.
answer
Answer: A
question
Which of the following would you use to find patterns in user interaction data recorded by Web servers?
A) Web usage mining
B) Web server mining
C) Web structure mining
D) Web content mining
answer
Answer: A
Diff: 2 Page Ref: 205
question
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?
A) Web usage mining
B) Web server mining
C) Web structure mining
D) Web content mining
answer
Answer: C
Diff: 2 Page Ref: 203-205
question
Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function.
A) database administration
B) data administration
C) server administration
D) data modeling
answer
Answer: A
question
Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos.
A) Hadoop
B) Web mining
C) text mining
D) OLAP
answer
Answer: C
question
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
A) data auditing.
B) defragmentation.
C) data scrubbing.
D) data optimization.
answer
Answer: C
When I defined data scrubbing earlier in this document, I gave one example of why data scrubbing would be needed. Here you are seeing more reasons why data scrubbing would be needed.
question
A DBMS is special software for creating, storing, organizing, and accessing data from a database.
answer
Answer: TRUE
Diff: 2 Page Ref: 193
question
A physical view shows data as it is organized on the storage media.
answer
Answer: TRUE
Diff: 2 Page Ref: 193
question
End users use a data manipulation language to add, edit, delete data in the database.
answer
Answer: TRUE
question
Hadoop is a(n):
A) NoSQL database technology that stores both data and procedures acting on the data as objects.
B) data mining platform designed for storing and analyzing big data produced by Web communications and transactions.
C) open-source software framework designed for distributing data-processing over inexpensive computers.
D) pre-configured hardware-software system designed for analyzing big data.
answer
Answer: C
question
A data ________ stores current and historical data of potential interest to decision makers throughout the company.
A) warehouse
B) mart
C) archive
D) mine
answer
Answer: A
Diff: 2 Page Ref: 199
question
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.
A) web server
B) application server
C) database server
D) client server
answer
Answer: C
Diff: 2 Page Ref: 206
question
An information policy specifies the procedures and rules for defining the structure and content of corporate databases.
answer
Answer: FALSE
Diff: 2 Page Ref: 206
question
Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.
answer
Answer: TRUE
Diff: 2 Page Ref: 207
question
A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.
A) data quality audit
B) systems analysis
C) systems audit
D) data analysis
answer
Answer: A
Diff: 3 Page Ref: 208
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
