Question 1

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)   foreign key.
E)   identifying field.F) C) and D)
G) None of the above

Question 2

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

Accepted Answer

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

Question 3

OLAP is used to quickly find answers to ad hoc questions.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following allows users to add, change, delete, or retrieve data in a database?

Accepted Answer

A)   Attribute generation
B)   Report generation tools
C)   Data dictionary
D)   Query wizard tool
E)   Data manipulation languageF) All of the above
G) B) and D)

Question 5

Sentiment analysis is used to identify patterns in blogs and social media conversations to detect favorable and unfavorable comments.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

In clustering, a data mining tool will find:

Accepted Answer

A)   new groupings within data.
B)   related predictions from existing values.
C)   several events grouped by time.
D)   new associations.
E)   forecasts for future events.F) C) and D)
G) C) and E)

Question 8

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Accepted Answer

A) True 
 B)False

Question 9

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 10

What are some of the benefits of using the cloud as a database platform?

Accepted Answer

Cloud-based data management services are...

Question 11

The smallest unit of data a computer can handle is called a:

Accepted Answer

A)   file.
B)   record.
C)   field.
D)   byte.
E)   bit.F) B) and C)
G) C) and E)

Question 12

Links pointing to an online document are a sign of:

Accepted Answer

A)   richness or variety of topics covered.
B)   popularity.
C)   data quality.
D)   data usage.
E)   marketing.F) C) and D)
G) B) and E)

Question 13

A characteristic or quality describing an entity is called a(n) :

Accepted Answer

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

Question 14

A small publishing company that you work for would like to develop a database that keeps track of the contracts that authors and publishers sign before starting a book. What fields do you anticipate needing for this database? Identify at least seven fields. Which of these fields might be in use in other databases within the firm?

Accepted Answer

Author first name, author last name, aut...

Question 15

DBMS typically include report-generating tools in order to:

Accepted Answer

A)   retrieve and display data.
B)   display data in tables.
C)   display data in graphs.
D)   perform predictive analysis.
E)   display data in an easier-to-read-format.F) B) and C)
G) A) and C)

Question 16

In-memory computing relies on a computer's main memory for storing data.

Accepted Answer

A) True 
 B)False

Question 17

All of the following are tools or technologies for extracting information from unstructured data sets except:

Accepted Answer

A)   sentiment analysis software.
B)   SQL queries.
C)   Hadoop.
D)   a non-relational DBMS.
E)   text mining.F) All of the above
G) B) and D)

Question 18

In linking databases to the web, the role of the application server is to host the DBMS.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following statements about data warehouses is not true?

Accepted Answer

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 website transactions.
D)   Data warehouse systems provide easy-to-use tools for managers to easily update data.
E)   Data warehouses make data available for anyone to access as needed.F) A) and C)
G) B) and C)

Question 20

Microsoft Access is a database management system for large mainframes computers.

Accepted Answer

A) True 
 B)False

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

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 Answer
verified
Data mining is one of the data analysis ...
View Answer

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

Correct Answer
verified

Correct Answer
verified
Author first name, author last name, aut...
View Answer

Links pointing to an online document are a sign of:

Correct Answer
verified

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

Correct Answer
verified

What are some of the benefits of using the cloud as a database platform?

Correct Answer
verified
Cloud-based data management services are...
View Answer

All of the following are tools or technologies for extracting information from unstructured data sets except:

Correct Answer
verified

In clustering, a data mining tool will find:

Correct Answer
verified

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

Correct Answer
verified

Which of the following allows users to add, change, delete, or retrieve data in a database?

Correct Answer
verified

Microsoft Access is a database management system for large mainframes computers.

Correct Answer
verified

Which of the following statements about data warehouses is not true?

Correct Answer
verified

DBMS typically include report-generating tools in order to:

Correct Answer
verified

In linking databases to the web, the role of the application server is to host the DBMS.

Correct Answer
verified

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Correct Answer
verified

OLAP is used to quickly find answers to ad hoc questions.

Correct Answer
verified

Sentiment analysis is used to identify patterns in blogs and social media conversations to detect favorable and unfavorable comments.

Correct Answer
verified

The smallest unit of data a computer can handle is called a:

Correct Answer
verified

In-memory computing relies on a computer's main memory for storing data.

Correct Answer
verified

A characteristic or quality describing an entity is called a(n) :

Correct Answer
verified

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

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

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedAuthor first name, author last name, aut...View AnswerShow Answer

Links pointing to an online document are a sign of:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are some of the benefits of using the cloud as a database platform?

Correct AnswerverifiedCloud-based data management services are...View AnswerShow Answer

All of the following are tools or technologies for extracting information from unstructured data sets except:

Correct AnswerverifiedShow Answer

In clustering, a data mining tool will find:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following allows users to add, change, delete, or retrieve data in a database?

Correct AnswerverifiedShow Answer

Microsoft Access is a database management system for large mainframes computers.

Correct AnswerverifiedShow Answer

Which of the following statements about data warehouses is not true?

Correct AnswerverifiedShow Answer

DBMS typically include report-generating tools in order to:

Correct AnswerverifiedShow Answer

In linking databases to the web, the role of the application server is to host the DBMS.

Correct AnswerverifiedShow Answer

DBMS simplify how end users work with databases by separating the logical and physical views of the data.

Correct AnswerverifiedShow Answer

OLAP is used to quickly find answers to ad hoc questions.

Correct AnswerverifiedShow Answer

Sentiment analysis is used to identify patterns in blogs and social media conversations to detect favorable and unfavorable comments.

Correct AnswerverifiedShow Answer

The smallest unit of data a computer can handle is called a:

Correct AnswerverifiedShow Answer

In-memory computing relies on a computer's main memory for storing data.

Correct AnswerverifiedShow Answer

A characteristic or quality describing an entity is called a(n) :

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified
Author first name, author last name, aut...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Cloud-based data management services are...
View 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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified