Question 1

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

Accepted Answer

A data definition capability to specify

Question 2

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

Accepted Answer

A) True 
 B)False

Question 3

The specialized language programmers use to add and change data in the database is called

Accepted Answer

A)  a data access language. 
B)  a data manipulation language. 
C)  structured query language. 
D)  a data definition language. 
E)  a DBMS. 
A)  a data access language. 
B)  a data manipulation language. 
C)  structured query language. 
D)  a data definition language. 
E)  a DBMS.

Question 4

The traditional file environment does not typically have a problem with

Accepted Answer

A)  data inconsistency. 
B)  program-data independence. 
C)  lack of flexibility in creating ad-hoc reports. 
D)  poor security. 
E)  data sharing. 
A)  data inconsistency. 
B)  program-data independence. 
C)  lack of flexibility in creating ad-hoc reports. 
D)  poor security. 
E)  data sharing.

Question 5

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)  unique ID. 
E)  key attribute. 
A)  primary key. 
B)  key field. 
C)  primary field. 
D)  unique ID. 
E)  key attribute.

Question 6

DBMSs typically include report-generating tools in order to

Accepted Answer

A)  retrieve and display data. 
B)  display data in an easier-to-read format. 
C)  display data in graphs. 
D)  perform predictive analysis. 
E)  analyse the database's performance. 
A)  retrieve and display data. 
B)  display data in an easier-to-read format. 
C)  display data in graphs. 
D)  perform predictive analysis. 
E)  analyse the database's performance.

Question 7

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

Accepted Answer

A) True 
 B)False

Question 8

OLAP is a tool for enabling

Accepted Answer

A)  users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B)  users to view both logical and physical views of data. 
C)  programmers to quickly diagram data relationships. 
D)  programmers to normalize data. 
E)  users to quickly generate summary reports. 
A)  users to obtain online answers to ad-hoc questions in a rapid amount of time. 
B)  users to view both logical and physical views of data. 
C)  programmers to quickly diagram data relationships. 
D)  programmers to normalize data. 
E)  users to quickly generate summary reports.

Question 9

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

Accepted Answer

Sales databases could be used to make th

Question 10

The join operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments. 
E)  creates a subset consisting of rows in a table. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  identifies the table from which the columns will be selected. 
C)  creates a subset consisting of columns in a table. 
D)  organizes elements into segments. 
E)  creates a subset consisting of rows in a table.

Question 11

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Accepted Answer

A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop 
E)  DBMS 
A)  OLAP 
B)  data warehouse 
C)  data mart 
D)  Hadoop 
E)  DBMS

Question 14

In terms of data relationships, 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)  relationships between different customers. 
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)  relationships between different customers.

Question 15

The special organizational function whose responsibilities include physical database design and maintenance is called

Accepted Answer

A)  data administration. 
B)  database administration. 
C)  information policy administration. 
D)  data auditing. 
E)  database management. 
A)  data administration. 
B)  database administration. 
C)  information policy administration. 
D)  data auditing. 
E)  database management.

Question 16

The logical and physical views of data are separated in a DBMS.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not one of the techniques used in Web mining?

Accepted Answer

A)  content mining 
B)  structure mining 
C)  server mining 
D)  usage mining 
E)  data mining 
A)  content mining 
B)  structure mining 
C)  server mining 
D)  usage mining 
E)  data mining

Question 20

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.

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

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

The specialized language programmers use to add and change data in the database is called

The traditional file environment does not typically have a problem with

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

DBMSs typically include report-generating tools in order to

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

OLAP is a tool for enabling

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

The join operation

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

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

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

In terms of data relationships, associations refers to

The special organizational function whose responsibilities include physical database design and maintenance is called

The logical and physical views of data are separated in a DBMS.

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

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Which of the following is not one of the techniques used in Web mining?

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

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

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

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

The specialized language programmers use to add and change data in the database is called

The traditional file environment does not typically have a problem with

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

DBMSs typically include report-generating tools in order to

In data mining, the technique of predicting uses a series of existing values to determine what other future values will be.

OLAP is a tool for enabling

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

The join operation

The coupling of data with the software programs that manipulate the data, such that changes in programs requires changes to the data, is called program-data dependence.

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

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

In terms of data relationships, associations refers to

The special organizational function whose responsibilities include physical database design and maintenance is called

The logical and physical views of data are separated in a DBMS.

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

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Which of the following is not one of the techniques used in Web mining?

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

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