Question 1

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. 
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.

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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. 
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.

Question 8

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. 
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.

Question 9

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 language 
A)  Attribute generation 
B)  Report generation tools 
C)  Data dictionary 
D)  Query wizard tool 
E)  Data manipulation language

Question 10

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. 
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.

Question 11

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. 
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.

Question 12

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 13

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

Accepted Answer

Cloud-based data management services are

Question 14

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. 
A)  richness or variety of topics covered. 
B)  popularity. 
C)  data quality. 
D)  data usage. 
E)  marketing.

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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 18

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. 
A)  sentiment analysis software. 
B)  SQL queries. 
C)  Hadoop. 
D)  a non-relational DBMS. 
E)  text mining.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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. 
A)  primary key. 
B)  key field. 
C)  primary field. 
D)  foreign key. 
E)  identifying field.

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

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?

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

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

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

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

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

In clustering, a data mining tool will find:

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

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

DBMS typically include report-generating tools in order to:

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

Links pointing to an online document are a sign of:

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

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

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

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

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

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

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

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

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

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?

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

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

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

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

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

In clustering, a data mining tool will find:

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

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

DBMS typically include report-generating tools in order to:

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

Links pointing to an online document are a sign of:

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

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

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

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

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

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

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters