Question 1

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is an example of a pre-digital database?

Accepted Answer

A)   A library's card-catalog
B)   A cash register receipt
C)   A doctor's office invoice
D)   A list of sales totals on a spreadsheet
E)   An SQL database

Question 3

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.

Question 4

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Accepted Answer

Text mining and web mining techniques wo...

Question 7

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A DBMS includes capabilities and tools f...

Question 8

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.

Question 9

Access is a:

Accepted Answer

A)   DBMS for mobile devices.
B)   popular open-source DBMS.
C)   DBMS for midrange computers.
D)   DBMS for desktop PC systems.
E)   DBMS for mainframe computers.

Question 10

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Accepted Answer

A) True 
 B)False

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.

Question 12

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Accepted Answer

A)   Gartner
B)   Fortune
C)   IBM
D)   Microsoft
E)   Facebook

Question 13

A data warehouse may include information from legacy systems.

Accepted Answer

A) True 
 B)False

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.

Question 15

A DBMS is special software for creating, storing, organizing, and accessing data from a database.

Accepted Answer

A) True 
 B)False

Question 16

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)   foreign key.
E)   identifying field.

Question 17

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Accepted Answer

A) True 
 B)False

Question 18

In terms of the data relationships found by data mining, associations refers to:

Accepted Answer

A)   events linked over time.
B)   patterns that describe a group to which an item belongs.
C)   occurrences linked to a single event.
D)   undiscovered groupings.
E)   classification when no groups have yet been defined.

Question 19

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

Accepted Answer

Student answers will vary; an example an...

Question 20

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A)   intersection relations
B)   one-to-one ordering
C)   entity-relationship diagrams
D)   foreign keys
E)   referential integrity rules

Exam 6: Foundations of Business Intelligence: Databases and

A DBMS is special software for creating, storing, organizing, and accessing data from a database.

Correct AnswerverifiedShow Answer

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Correct AnswerverifiedShow Answer

In terms of the data relationships found by data mining, associations refers to:

Correct AnswerverifiedShow Answer

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Correct AnswerverifiedText mining and web mining techniques wo...View AnswerShow Answer

Every record in a file should contain at least one key field.

Correct AnswerverifiedShow Answer

Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.

Correct AnswerverifiedShow Answer

Hadoop can process large quantities of any type of data, including video and Twitter feeds.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Access is a:

Correct AnswerverifiedShow Answer

Links pointing to an online document are a sign of:

Correct AnswerverifiedShow Answer

List and describe three main capabilities or tools of a DBMS.

Correct AnswerverifiedA DBMS includes capabilities and tools f...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

DBMS typically include report-generating tools in order to:

Correct AnswerverifiedShow Answer

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Correct AnswerverifiedShow Answer

Data cleansing is the same process as data scrubbing.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedStudent answers will vary; an example an...View AnswerShow Answer

Which of the following is an example of a pre-digital database?

Correct AnswerverifiedShow Answer

A data warehouse may include information from legacy systems.

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 Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Text mining and web mining techniques wo...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A DBMS includes capabilities and tools f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student answers will vary; an example an...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified