Question 1

A field identified in a record as holding the unique identifier for that record is called the

Accepted Answer

A)   primary key.
B)   key field.
C)   primary field.
D)   unique ID.
E)   key attribute.F) None of the above
G) B) and E)

Question 2

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Accepted Answer

A)   Batch processing
B)   Data redundancy
C)   Data independence
D)   Online processing
E)   Data qualityF) B) and E)
G) A) and B)

Question 3

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.F) B) and E)
G) All of the above

Question 4

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Accepted Answer

A)   text mining tools
B)   sentiment analysis software
C)   Web usage mining technologies
D)   data mining software for identifying associations
E)   data mining software for forecastingF) B) and E)
G) B) and D)

Question 5

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Accepted Answer

A) True 
 B)False

Question 6

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

Student answers will vary, but should in...

Question 7

The special organizational function whose responsibilities include physical database design and maintenance is called

Accepted Answer

A)   data administration.
B)   database administration.
C)   information policy administration.
D)   data auditing.
E)   database management.F) B) and E)
G) A) and B)

Question 8

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 9

The logical and physical views of data are separated in a DBMS.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is not a DBMS for midrange computers?

Accepted Answer

A)   DB2
B)   Oracle
C)   Microsoft SQL Server
D)   Microsoft Access
E)   Microsoft ExchangeF) A) and B)
G) None of the above

Question 11

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing?
 Which of these fields might be in use in other databases used by the company?

Accepted Answer

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

Question 12

The specialized language programmers use to add and change data in the database is called

Accepted Answer

A)   a data access language.
B)   a data manipulation language.
C)   structured query language.
D)   a data definition language.
E)   a DBMS.F) B) and C)
G) B) 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 C)
G) C) and E)

Question 14

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.F) A) and B)
G) A) and C)

Question 15

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Accepted Answer

A) True 
 B)False

Question 16

DBMSs typically include report-generating tools in order to

Accepted Answer

A)   retrieve and display data.
B)   display data in an easier-to-read format.
C)   display data in graphs.
D)   perform predictive analysis.
E)   analyse the database's performance.F) B) and D)
G) C) and D)

Question 17

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) A) and D)
G) A) and E)

Question 18

In a relational database, the three basic operations used to develop useful sets of data are

Accepted Answer

A)   select, project, and where.
B)   select, join, and where.
C)   select, project, and join.
D)   where, from, and join.
E)   where, find, and select.F) A) and D)
G) A) and C)

Question 19

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

Accepted Answer

A) True 
 B)False

Question 20

In a table for customers, the information about a single customer would reside in a single

Accepted Answer

A)   field.
B)   row.
C)   column.
D)   table.
E)   entity.F) A) and B)
G) B) and D)

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

The project operation

Correct Answer
verified

In a table for customers, the information about a single customer would reside in a single

Correct Answer
verified

A field identified in a record as holding the unique identifier for that record is called the

Correct Answer
verified

DBMSs typically include report-generating tools in order to

Correct Answer
verified

Which of the following is not a DBMS for midrange computers?

Correct Answer
verified

The join operation

Correct Answer
verified

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

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

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

Correct Answer
verified

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?

Correct Answer
verified
Student answers will vary, but should in...
View Answer

The special organizational function whose responsibilities include physical database design and maintenance is called

Correct Answer
verified

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Correct Answer
verified

The logical and physical views of data are separated in a DBMS.

Correct Answer
verified

The specialized language programmers use to add and change data in the database is called

Correct Answer
verified

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Correct Answer
verified

In a relational database, the three basic operations used to develop useful sets of data are

Correct Answer
verified

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

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Correct Answer
verified

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Correct Answer
verified

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

The project operation

Correct AnswerverifiedShow Answer

In a table for customers, the information about a single customer would reside in a single

Correct AnswerverifiedShow Answer

A field identified in a record as holding the unique identifier for that record is called the

Correct AnswerverifiedShow Answer

DBMSs typically include report-generating tools in order to

Correct AnswerverifiedShow Answer

Which of the following is not a DBMS for midrange computers?

Correct AnswerverifiedShow Answer

The join operation

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

To analyze unstructured data, such as memos and legal cases, you would use text mining tools.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedStudent answers will vary, but should in...View AnswerShow Answer

The special organizational function whose responsibilities include physical database design and maintenance is called

Correct AnswerverifiedShow Answer

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Correct AnswerverifiedShow Answer

The logical and physical views of data are separated in a DBMS.

Correct AnswerverifiedShow Answer

The specialized language programmers use to add and change data in the database is called

Correct AnswerverifiedShow Answer

________ creates confusion that hampers the creation of information systems that integrate data from different sources.

Correct AnswerverifiedShow Answer

In a relational database, the three basic operations used to develop useful sets of data are

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

Correct AnswerverifiedShow Answer

When you design the new contracts database for the publishing house mentioned above, what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

With in-memory computing, a computer's primary memory (RAM) is used for processing.

Correct AnswerverifiedShow Answer

A household appliances manufacturer has hired you to help analyze their social media datasets to determine which of their refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
Student answers will vary, but should in...
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
Author first name, author last name, aut...
View Answer

Correct Answer
verified

Correct Answer
verified