Question 1

Identify and describe three basic operations used to extract useful sets of data from a relational database.

Accepted Answer

The select operation creates a subset co

Question 2

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

Accepted Answer

A)  enforces referential integrity 
B)  couples program and data 
C)  data dictionary 
D)  two-dimensional tables 
E)  minimizes isolated files with repeated data 
A)  enforces referential integrity 
B)  couples program and data 
C)  data dictionary 
D)  two-dimensional tables 
E)  minimizes isolated files with repeated data

Question 4

The tool that enables users to view the same data in different ways using multiple dimensions is

Accepted Answer

A)  predictive analysis. 
B)  SQL. 
C)  OLAP. 
D)  data mining. 
E)  Hadoop. 
A)  predictive analysis. 
B)  SQL. 
C)  OLAP. 
D)  data mining. 
E)  Hadoop.

Question 5

All of the following are technologies used to analyze and manage big data except

Accepted Answer

A)  cloud computing. 
B)  noSQL. 
C)  in-memory computing. 
D)  analytic platforms. 
E)  Hadoop. 
A)  cloud computing. 
B)  noSQL. 
C)  in-memory computing. 
D)  analytic platforms. 
E)  Hadoop.

Question 6

A database record is a grouping of characters into a word, a group of words, or a complete number.

Accepted Answer

A) True 
 B)False

Question 7

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI.

Accepted Answer

A) True 
 B)False

Question 8

Data mining is a tool for allowing users to

Accepted Answer

A)  quickly compare transaction data gathered over many years. 
B)  find hidden relationships in data. 
C)  obtain online answers to ad-hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  access the vast amounts of data in a data warehouse. 
A)  quickly compare transaction data gathered over many years. 
B)  find hidden relationships in data. 
C)  obtain online answers to ad-hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  access the vast amounts of data in a data warehouse.

Question 9

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Accepted Answer

A)  data dictionary. 
B)  data definition diagram. 
C)  entity-relationship diagram. 
D)  relationship dictionary. 
E)  data table. 
A)  data dictionary. 
B)  data definition diagram. 
C)  entity-relationship diagram. 
D)  relationship dictionary. 
E)  data table.

Question 10

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Accepted Answer

A)  address 
B)  city 
C)  airport code 
D)  state 
E)  day 
A)  address 
B)  city 
C)  airport code 
D)  state 
E)  day

Question 11

A(n) ________ organizes data in two-dimensional tables.

Accepted Answer

A)  non-relational DBMS 
B)  mobile DBMS 
C)  relational DBMS 
D)  hierarchical DBMS 
E)  object-oriented DBMS 
A)  non-relational DBMS 
B)  mobile DBMS 
C)  relational DBMS 
D)  hierarchical DBMS 
E)  object-oriented DBMS

Question 12

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 13

To perform multidimensional data analysis, you would use OLAP.

Accepted Answer

A) True 
 B)False

Question 14

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

A) True 
 B)False

Question 15

You can manipulate data on a Web server by using a CGI script.

Accepted Answer

A) True 
 B)False

Question 16

Data cleansing not only corrects errors but also

Accepted Answer

A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  removes duplicate data. 
E)  enforces consistency among different sets of data. 
A)  establishes logical relationships between data. 
B)  structures data. 
C)  normalizes data. 
D)  removes duplicate data. 
E)  enforces consistency among different sets of data.

Question 17

Legacy systems are used to populate and update data warehouses.

Accepted Answer

A) True 
 B)False

Question 18

What makes data mining an important business tool?
 What types of information does data mining produce?
 In what type of circumstance would you advise a company to use data mining?

Accepted Answer

Data mining is one of the data analysis

Question 19

Big data does not refer to

Accepted Answer

A)  datasets with fewer than a billion records. 
B)  datasets with unstructured data. 
C)  machine-generated data (i.e. from sensors). 
D)  data created by social media (i.e. tweets, Facebook Likes). 
E)  data from Web traffic. 
A)  datasets with fewer than a billion records. 
B)  datasets with unstructured data. 
C)  machine-generated data (i.e. from sensors). 
D)  data created by social media (i.e. tweets, Facebook Likes). 
E)  data from Web traffic.

Question 20

Which of the following is not a method for performing a data quality audit?

Accepted Answer

A)  surveying entire data files 
B)  surveying samples from data files 
C)  surveying data definition and query files 
D)  surveying end users about their perceptions of data quality 
E)  surveying managers about their perceptions of data quality 
A)  surveying entire data files 
B)  surveying samples from data files 
C)  surveying data definition and query files 
D)  surveying end users about their perceptions of data quality 
E)  surveying managers about their perceptions of data quality

Identify and describe three basic operations used to extract useful sets of data from a relational database.

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

The tool that enables users to view the same data in different ways using multiple dimensions is

All of the following are technologies used to analyze and manage big data except

A database record is a grouping of characters into a word, a group of words, or a complete number.

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI.

Data mining is a tool for allowing users to

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

A(n) ________ organizes data in two-dimensional tables.

Multiple data marts are combined and streamlined to create a data warehouse.

To perform multidimensional data analysis, you would use OLAP.

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

You can manipulate data on a Web server by using a CGI script.

Data cleansing not only corrects errors but also

Legacy systems are used to populate and update data warehouses.

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Big data does not refer to

Which of the following is not a method for performing a data quality audit?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

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

Identify and describe three basic operations used to extract useful sets of data from a relational database.

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Which of the following features enables a DBMS to reduce data redundancy and inconsistency?

The tool that enables users to view the same data in different ways using multiple dimensions is

All of the following are technologies used to analyze and manage big data except

A database record is a grouping of characters into a word, a group of words, or a complete number.

The DBMS programming language that end users and programmers use to manipulate data in the database is called CGI.

Data mining is a tool for allowing users to

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

A(n) ________ organizes data in two-dimensional tables.

Multiple data marts are combined and streamlined to create a data warehouse.

To perform multidimensional data analysis, you would use OLAP.

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

You can manipulate data on a Web server by using a CGI script.

Data cleansing not only corrects errors but also

Legacy systems are used to populate and update data warehouses.

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?

Big data does not refer to

Which of the following is not a method for performing a data quality audit?

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters