Question 1

The most prominent data manipulation language today is

Accepted Answer

A) Access. 
B) DB2. 
C) SQL. 
D) Crystal Reports. 
E) NoSQL.

Question 2

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

Accepted Answer

A) True 
 B)False

Question 3

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Accepted Answer

The answer of Identify and describe three basic operations used...

Question 4

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 5

The select operation

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) identifies the table from which the columns will be selected. 
D) creates a subset consisting of all records in the file that meet stated criteria. 
E) creates a subset consisting of rows in a table.

Question 6

You can manipulate data on a Web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 7

In a client/server environment,a DBMS is located on a dedicated computer called a Web server.

Accepted Answer

A) True 
 B)False

Question 8

The project operation

Accepted Answer

A) combines relational tables to provide the user with more information than is otherwise available. 
B) creates a subset consisting of columns in a table. 
C) organizes elements into segments. 
D) identifies the table from which the columns will be selected. 
E) creates a subset consisting of rows in a table.

Question 9

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

Accepted Answer

A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data defining. 
E) optimization.

Question 10

You work for a retail clothing chain whose primary outlets are in shopping malls,and you are conducting an analysis of your customers and their preferences.You wish to find out if there are any particular activities that your customers engage in,or the types of purchases made in the month before or after purchasing select items from your store.To do this,you will want to use data mining software that is capable of

Accepted Answer

A) identifying associations. 
B) identifying clusters. 
C) identifying sequences. 
D) classification. 
E) forecasting.

Question 11

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Accepted Answer

A) data normalization 
B) data accuracy 
C) data redundancy 
D) data inconsistency 
E) data duplication

Question 12

A DBMS makes the

Accepted Answer

A) physical database available for different logical views. 
B) relational database available for different logical views. 
C) physical database available for different analytic views. 
D) relational database available for different analytic views. 
E) logical database available for different analytic views.

Question 13

________ tools are used to analyze large unstructured data sets,such as e-mail,memos,survey responses,etc.,to discover patterns and relationships.

Accepted Answer

A) OLAP 
B) Text mining 
C) In-memory 
D) Clustering 
E) Classification

Question 14

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

Accepted Answer

The answer of Describe the ways in which database technologies...

Question 15

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

Accepted Answer

A) data dictionary. 
B) data definition diagram. 
C) entity-relationship diagram. 
D) relationship dictionary. 
E) data table.

Question 16

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

Accepted Answer

The answer of The small publishing company you work for...

Question 17

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

Accepted Answer

A) enforces referential integrity 
B) couples program and data 
C) data dictionary 
D) two-dimensional tables 
E) minimizes isolated files with repeated data

Question 19

To perform multidimensional data analysis,you would use OLAP.

Accepted Answer

A) True 
 B)False

Question 20

Data scrubbing is a more intensive corrective process than data cleansing.

Accepted Answer

A) True 
 B)False

Exam 6: Foundations of Business Intelligence: Databases and Information Management

The most prominent data manipulation language today is

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Multiple data marts are combined and streamlined to create a data warehouse.

The select operation

You can manipulate data on a Web server by using a CGI script.

In a client/server environment,a DBMS is located on a dedicated computer called a Web server.

The project operation

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

A DBMS makes the

________ tools are used to analyze large unstructured data sets,such as e-mail,memos,survey responses,etc.,to discover patterns and relationships.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve low-cost leadership.

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

NoSQL technologies are used to manage sets of data that don't require the flexibility of tables and relations.

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

To perform multidimensional data analysis,you would use OLAP.

Data scrubbing is a more intensive corrective process than data cleansing.