Question 1

The select 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)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  specifies the content of the database. 
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)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  specifies the content of the database.

Question 2

In a relational database, a record is also called a(n):

Accepted Answer

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

Question 3

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Data cleansing is the same process as data scrubbing.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

CGI is a specification for processing data on a web server.

Accepted Answer

A) True 
 B)False

Question 9

From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems?

Accepted Answer

A)  Online ticket sales were falling. 
B)  There were too many sources of data. 
C)  The entities and attributes of customer records were poorly organized. 
D)  There was too much unorganized customer data for decision makers to digest. 
E)  The team's computer hardware was outdated. 
A)  Online ticket sales were falling. 
B)  There were too many sources of data. 
C)  The entities and attributes of customer records were poorly organized. 
D)  There was too much unorganized customer data for decision makers to digest. 
E)  The team's computer hardware was outdated.

Question 10

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

Data mining uncovers hidden relationship

Question 11

Which of the following enables users to view the same data in different ways using multiple dimensions?

Accepted Answer

A)  Hadoop 
B)  SQL 
C)  Big data 
D)  Data mining 
E)  OLAP 
A)  Hadoop 
B)  SQL 
C)  Big data 
D)  Data mining 
E)  OLAP

Question 12

A data warehouse is best used for storing unstructured data.

Accepted Answer

A) True 
 B)False

Question 13

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

MongoDB and SimpleDB are both examples of:

Accepted Answer

A)  open source databases. 
B)  SQL databases. 
C)  NoSQL databases. 
D)  cloud databases. 
E)  big data databases. 
A)  open source databases. 
B)  SQL databases. 
C)  NoSQL databases. 
D)  cloud databases. 
E)  big data databases.

Question 16

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 17

Web servers can directly access a firm's back-end databases using HTML.

Accepted Answer

A) True 
 B)False

Question 18

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Accepted Answer

A)  Hadoop 
B)  web mining 
C)  text mining 
D)  OLAP 
E)  DBMS 
A)  Hadoop 
B)  web mining 
C)  text mining 
D)  OLAP 
E)  DBMS

Question 19

Hadoop is a(n):

Accepted Answer

A)  NoSQL database technology that stores both data and procedures acting on the data as objects. 
B)  data mining platform designed for storing and analyzing big data produced by web communications and transactions. 
C)  open source software framework designed for distributing data-processing over inexpensive computers. 
D)  pre-configured hardware-software system designed for analyzing big data. 
E)  high-speed platform used to analyze large data sets. 
A)  NoSQL database technology that stores both data and procedures acting on the data as objects. 
B)  data mining platform designed for storing and analyzing big data produced by web communications and transactions. 
C)  open source software framework designed for distributing data-processing over inexpensive computers. 
D)  pre-configured hardware-software system designed for analyzing big data. 
E)  high-speed platform used to analyze large data sets.

Question 20

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

The select operation:

In a relational database, a record is also called a(n):

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

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

Data cleansing is the same process as data scrubbing.

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

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

CGI is a specification for processing data on a web server.

From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems?

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Which of the following enables users to view the same data in different ways using multiple dimensions?

A data warehouse is best used for storing unstructured data.

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

A DBMS makes the:

MongoDB and SimpleDB are both examples of:

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

Web servers can directly access a firm's back-end databases using HTML.

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Hadoop is a(n):

A field identified in a record as holding the unique identifier for that record 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

The select operation:

In a relational database, a record is also called a(n):

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

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

Data cleansing is the same process as data scrubbing.

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

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

CGI is a specification for processing data on a web server.

From your reading of the chapter-opening case study, the Charlotte Hornets implemented a data warehouse in order to solve which of the following problems?

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Which of the following enables users to view the same data in different ways using multiple dimensions?

A data warehouse is best used for storing unstructured data.

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

A DBMS makes the:

MongoDB and SimpleDB are both examples of:

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

Web servers can directly access a firm's back-end databases using HTML.

Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos.

Hadoop is a(n):

A field identified in a record as holding the unique identifier for that record 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