Question 1

A record is a group of related fields.

Accepted Answer

A) True 
 B)False

Question 2

A database ________ describes a database entity.

Accepted Answer

A)  byte
B)  field
C)  record
D)  value
E)  fileF) A) and E)
G) A) and D)

Question 3

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

Product databases could be made availabl...

Question 4

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Accepted Answer

Data mining is one of the data analysis ...

Question 5

In a relational database,a record is referred to in technical terms as a(n) :

Accepted Answer

A)  tuple.
B)  table.
C)  entity.
D)  field.
E)  key.F) D) and E)
G) C) and D)

Question 6

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

Accepted Answer

The select operation creates a subset co...

Question 7

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:

Accepted Answer

A)  one short mark.
B)  two short marks.
C)  three short marks.
D)  a crow's foot.
E)  a crow's foot topped by a short mark.F) A) and B)
G) A) and C)

Question 8

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Accepted Answer

A) True 
 B)False

Question 9

All of the following are technologies used to analyze and manage big data except:

Accepted Answer

A)  cloud computing.
B)  noSQL.
C)  in-memory computing.
D)  analytic platforms.
E)  Hadoop.F) A) and D)
G) A) and C)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The join operation:

Accepted Answer

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

Question 12

Which of the following occurs when the same attribute in related data files has different values?

Accepted Answer

A)  Data redundancy
B)  Data duplication
C)  Data dependence
D)  Data discrepancy
E)  Data inconsistencyF) A) and B)
G) C) and D)

Question 13

A field identified in a table as holding the unique identifier of the table's records is called the:

Accepted Answer

A)  primary key.
B)  key field.
C)  primary field.
D)  unique ID.
E)  primary entity.F) A) and B)
G) C) and E)

Question 14

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

Accepted Answer

The first step is to perform a data qual...

Question 15

A(n) ________ represent data as two-dimensional tables.

Accepted Answer

A)  non-relational DBMS
B)  mobile DBMS
C)  relational DBMS
D)  hierarchical DBMS
E)  object-oriented DBMSF) C) and E)
G) B) and C)

Question 16

A characteristic or quality that describes a particular database entity is called a(n) :

Accepted Answer

A)  field.
B)  tuple.
C)  key field.
D)  attribute.
E)  relationship.F) A) and E)
G) A) and D)

Question 17

You can use OLAP to perform multidimensional data analysis.

Accepted Answer

A) True 
 B)False

Question 18

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

Accepted Answer

A)  Data administration
B)  Database administration
C)  Information policy administration
D)  Data auditing
E)  Database managementF) All of the above
G) D) and E)

Question 19

List three ways that a business's data can become redundant or inconsistent.

Accepted Answer

Data redundancy and inconsistency can oc...

Question 20

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

A) True 
 B)False

Exam 6: Foundations of Business Intelligence:

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

Correct AnswerverifiedShow Answer

You can use OLAP to perform multidimensional data analysis.

Correct AnswerverifiedShow Answer

The join operation:

Correct AnswerverifiedShow Answer

All of the following are technologies used to analyze and manage big data except:

Correct AnswerverifiedShow Answer

Which of the following occurs when the same attribute in related data files has different values?

Correct AnswerverifiedShow Answer

A characteristic or quality that describes a particular database entity is called a(n) :

Correct AnswerverifiedShow Answer

A record is a group of related fields.

Correct AnswerverifiedShow Answer

A field identified in a table as holding the unique identifier of the table's records is called the:

Correct AnswerverifiedShow Answer

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Correct AnswerverifiedData mining is one of the data analysis ...View AnswerShow Answer

In a large organization,which of the following functions would be responsible for policies and procedures for managing internal data resources?

Correct AnswerverifiedShow Answer

A database ________ describes a database entity.

Correct AnswerverifiedShow Answer

A(n) ________ represent data as two-dimensional tables.

Correct AnswerverifiedShow Answer

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

Correct AnswerverifiedThe first step is to perform a data qual...View AnswerShow Answer

The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Correct AnswerverifiedProduct databases could be made availabl...View AnswerShow Answer

In a relational database,a record is referred to in technical terms as a(n) :

Correct AnswerverifiedShow Answer

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe select operation creates a subset co...View AnswerShow Answer

List three ways that a business's data can become redundant or inconsistent.

Correct AnswerverifiedData redundancy and inconsistency can oc...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data mining is one of the data analysis ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The first step is to perform a data qual...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Product databases could be made availabl...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The select operation creates a subset co...
View Answer

Correct Answer
verified
Data redundancy and inconsistency can oc...
View Answer