Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 mining 
A)  Web usage mining 
B)  Web server mining 
C)  Web structure mining 
D)  Web content mining 
E)  Web protocol mining

Question 3

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

Question 4

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

Question 5

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 server 
A)  web server 
B)  online server 
C)  database server 
D)  client server 
E)  application server

Question 6

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

Question 7

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

Question 8

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 9

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 attributes 
A)  Relationships between rows and columns 
B)  Relationships between entities 
C)  Relationships between fields and records 
D)  Relationships between databases 
E)  Relationships between attributes

Question 10

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. 
A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data administration. 
E)  data management.

Question 11

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

Question 12

Data mining is more ________ than OLAP.

Accepted Answer

A)  data-focused 
B)  multidimensional 
C)  query oriented 
D)  discovery driven 
E)  streamlined 
A)  data-focused 
B)  multidimensional 
C)  query oriented 
D)  discovery driven 
E)  streamlined

Question 13

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. 
A)  derived table. 
B)  intersection relation. 
C)  foreign table. 
D)  entity-relationship table. 
E)  derived relation.

Question 14

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. 
A)  hybrid DBMS. 
B)  Hadoop. 
C)  BI. 
D)  analytic platforms. 
E)  data marts.

Question 15

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

Question 16

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

Question 17

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 overview 
A)  data quality audit 
B)  systems analysis 
C)  systems audit 
D)  data analysis 
E)  data overview

Question 18

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. 
A)  data auditing. 
B)  defragmentation. 
C)  data scrubbing. 
D)  data optimization. 
E)  data repair.

Question 19

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

Accepted Answer

DBMS include tools for accessing and man

Question 20

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. 
A)  SQL DBMS 
B)  Open-source DBMS 
C)  Non-relational DBMS 
D)  Cloud-based database 
E)  NoSQL DBMS.

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

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

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

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

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

The most basic business database is comprised of:

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

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

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

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

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

Data mining is more ________ than OLAP.

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

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

The logical view of a database:

A DBMS makes the:

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

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

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

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

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:

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

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

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

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

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

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

The most basic business database is comprised of:

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

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

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

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

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

Data mining is more ________ than OLAP.

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

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

The logical view of a database:

A DBMS makes the:

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

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

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

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

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:

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters