Question 1

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

Accepted Answer

A)   data auditing.
B)   defragmentation.
C)   data scrubbing.
D)   data optimization.
E)   data repair.F) A) and B)
G) A) and C)

Question 2

A table that links two tables that have a many-to-many relationship is often called a(n) :

Accepted Answer

A)   derived table.
B)   intersection relation.
C)   foreign table.
D)   entity-relationship table.
E)   derived relation.F) B) and C)
G) D) and E)

Question 3

The logical view of a database:

Accepted Answer

A)   shows how data are organized and structured on the storage media.
B)   presents an entry screen to the user.
C)   allows the creation of supplementary reports.
D)   presents data as they would be perceived by end users.
E)   shows the relationships between entities and attributes.F) B) and C)
G) A) and D)

Question 4

A(n)  ________ is a dedicated computer in a client/server environment that hosts a DBMS.

Accepted Answer

A)   web server
B)   online server
C)   database server
D)   client server
E)   application serverF) A) and B)
G) None of the above

Question 5

The most basic business database is comprised of:

Accepted Answer

A)   three tables: for suppliers, parts, and sales.
B)   four tables: for customers, suppliers, parts, and sales.
C)   four tables: for customers, suppliers, sales, and employees.
D)   five tables: for customers, employees, suppliers, parts, and sales.
E)   attributes instead of tables.F) A) and B)
G) A) and C)

Question 6

A physical view shows data as it is organized on the storage media.

Accepted Answer

A) True 
 B)False

Question 7

Data mining is more ________ than OLAP.

Accepted Answer

A)   data-focused
B)   multidimensional
C)   query oriented
D)   discovery driven
E)   streamlinedF) All of the above
G) A) and E)

Question 8

In terms of the data relationships found by data mining, sequences 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)   classifications when no groups have yet been defined.F) A) and E)
G) A) and C)

Question 9

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

Question 10

Which of the following database types would be best suited for storing multimedia?

Accepted Answer

A)   SQL DBMS
B)   Open-source DBMS
C)   Non-relational DBMS
D)   Cloud-based database
E)   NoSQL DBMS.F) B) and C)
G) C) and D)

Question 11

What are the relationships that the relational database is named for?

Accepted Answer

A)   Relationships between rows and columns
B)   Relationships between entities
C)   Relationships between fields and records
D)   Relationships between databases
E)   Relationships between attributesF) A) and C)
G) A) and B)

Question 12

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)   select, from, and join.
E)   who, what, and where.F) A) and B)
G) A) and C)

Question 13

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:

Accepted Answer

A)   hybrid DBMS.
B)   Hadoop.
C)   BI.
D)   analytic platforms.
E)   data marts.F) A) and E)
G) C) and D)

Question 14

A DBMS makes the:

Accepted Answer

A)   relational database available for different analytical views.
B)   logical database available for different analytical views.
C)   physical database available for different relational views.
D)   relational database available for different physical views.
E)   physical database available for different logical views.F) None of the above
G) A) and E)

Question 15

Which of the following would you use to find patterns in user interaction data recorded by web servers?

Accepted Answer

A)   Web usage mining
B)   Web server mining
C)   Web structure mining
D)   Web content mining
E)   Web protocol miningF) B) and C)
G) C) and E)

Question 16

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Accepted Answer

A)   normalization.
B)   data scrubbing.
C)   data cleansing.
D)   data administration.
E)   data management.F) C) and D)
G) A) and E)

Question 17

Describe the process of querying and reporting in a database using DBMS.

Accepted Answer

DBMS include tools for accessing and man...

Question 18

What is the purpose of a DBMS's data definition function?

Accepted Answer

A)   Storing and managing the data in the database
B)   Storing definitions of data elements
C)   Normalizing the database
D)   Structuring the database
E)   Ensuring consistency of relationshipsF) A) and B)
G) A) and C)

Question 19

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A)   The entity CUSTOMER with the attribute PRODUCT
B)   The entity CUSTOMER with the attribute ADDRESS
C)   The entity PRODUCT with the attribute PURCHASE
D)   The entity PRODUCT with the attribute CUSTOMER
E)   The entity ADDRESS with the attribute CUSTOMERF) A) and B)
G) All of the above

Question 20

A(n)  ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

Accepted Answer

A)   data quality audit
B)   systems analysis
C)   systems audit
D)   data analysis
E)   data overviewF) A) and D)
G) C) and E)

Exam 6: Foundations of Business Intelligence: Databases and

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:

Correct AnswerverifiedShow Answer

A DBMS makes the:

Correct AnswerverifiedShow Answer

Data mining is more ________ than OLAP.

Correct AnswerverifiedShow Answer

What is the purpose of a DBMS's data definition function?

Correct AnswerverifiedShow Answer

Which of the following best illustrates the relationship between entities and attributes?

Correct AnswerverifiedShow Answer

A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS.

Correct AnswerverifiedShow Answer

Which of the following would you use to find patterns in user interaction data recorded by web servers?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system.

Correct AnswerverifiedShow Answer

Describe the process of querying and reporting in a database using DBMS.

Correct AnswerverifiedDBMS include tools for accessing and man...View AnswerShow Answer

Which of the following database types would be best suited for storing multimedia?

Correct AnswerverifiedShow Answer

What are the relationships that the relational database is named for?

Correct AnswerverifiedShow Answer

A physical view shows data as it is organized on the storage media.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A table that links two tables that have a many-to-many relationship is often called a(n) :

Correct AnswerverifiedShow Answer

Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:

Correct AnswerverifiedShow Answer

The most basic business database is comprised of:

Correct AnswerverifiedShow Answer

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The logical view of a database:

Correct AnswerverifiedShow 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
DBMS include tools for accessing and man...
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