Question 1

The objective of BI is to improve the timeliness and quality of the input to the decision making process.

Accepted Answer

A) True 
 B)False

Question 2

What does it mean for a data warehouse to be multidimensional?

Accepted Answer

A)  The database stores data, facts, and definitions for all stored information 
B)  Data can be linked to other sources of internal and external information 
C)  The files stored in a warehouse contain multiple layers of columns and rows 
D)  Customer information can be related to sales, departmental, and organizational information 
A)  The database stores data, facts, and definitions for all stored information 
B)  Data can be linked to other sources of internal and external information 
C)  The files stored in a warehouse contain multiple layers of columns and rows 
D)  Customer information can be related to sales, departmental, and organizational information

Question 3

In an organization, _____ plans for, oversees the development of, and monitors the information resource.

Accepted Answer

The answer of In an organization, _____ plans for, oversees...

Question 4

_____ is a standardized fourth-generation query language found in most DBMSs.

Accepted Answer

Structured

Question 5

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

Accepted Answer

A)  Data definition subsystem 
B)  Data manipulation subsystem 
C)  Application generator 
D)  Data administration subsystem 
A)  Data definition subsystem 
B)  Data manipulation subsystem 
C)  Application generator 
D)  Data administration subsystem

Question 6

The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

Accepted Answer

A) True 
 B)False

Question 7

If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with?

Accepted Answer

A)  Data warehouse 
B)  Operational database 
C)  Transactional database 
D)  Data mart 
A)  Data warehouse 
B)  Operational database 
C)  Transactional database 
D)  Data mart

Question 8

A(n) _____ is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Accepted Answer

The answer of A(n) _____ is a logical collection of...

Question 9

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

Accepted Answer

A)  Hierarchical 
B)  File-based 
C)  Relational 
D)  Conventional 
A)  Hierarchical 
B)  File-based 
C)  Relational 
D)  Conventional

Question 10

Which type of environment allows you to go beyond operational database systems to support business intelligence?

Accepted Answer

A)  Transactional systems 
B)  Application generators 
C)  Data Warehouses 
D)  Relational DBMS 
A)  Transactional systems 
B)  Application generators 
C)  Data Warehouses 
D)  Relational DBMS

Question 11

A(n) _____ is a field that uniquely identifies each record.

Accepted Answer

The answer of A(n) _____ is a field that uniquely...

Question 12

Query optimization facilities are used to create backups just in case the database is damaged or lost.

Accepted Answer

A) True 
 B)False

Question 13

What must you define before adding any information to a relational database?

Accepted Answer

A)  The intended audience 
B)  The physical hardware structure 
C)  The administrative rights of users 
D)  The logical structure of the database 
A)  The intended audience 
B)  The physical hardware structure 
C)  The administrative rights of users 
D)  The logical structure of the database

Question 14

XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

Accepted Answer

A) True 
 B)False

Question 15

If you needed to store facts about information that you were collecting, you would store these facts in the _____.

Accepted Answer

A)  Relations 
B)  Database management system 
C)  Business rules 
D)  Data dictionary 
A)  Relations 
B)  Database management system 
C)  Business rules 
D)  Data dictionary

Question 16

_____ permit users to examine the impact of proposed structural changes on a database.

Accepted Answer

Change man

Question 17

A(n) _____ can provide up-to-the-minute snapshots of any type of information and can often help you identify trends that may represent opportunities or that may be problems.

Accepted Answer

The answer of A(n) _____ can provide up-to-the-minute snapshots of...

Question 18

What is the type of field, or group of fields, that can uniquely identify each record in a database?

Accepted Answer

A)  Identifying 
B)  Relational 
C)  Primary key 
D)  Main field 
A)  Identifying 
B)  Relational 
C)  Primary key 
D)  Main field

Question 19

_____ is responsible for the more technical and operational aspects of managing the information contained in organizational databases.

Accepted Answer

Database a

Question 20

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

Accepted Answer

A)  Logical view 
B)  Physical view 
C)  Stored view 
D)  Objective view 
A)  Logical view 
B)  Physical view 
C)  Stored view 
D)  Objective view

The objective of BI is to improve the timeliness and quality of the input to the decision making process.

What does it mean for a data warehouse to be multidimensional?

In an organization, _____ plans for, oversees the development of, and monitors the information resource.

_____ is a standardized fourth-generation query language found in most DBMSs.

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with?

A(n) _____ is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

Which type of environment allows you to go beyond operational database systems to support business intelligence?

A(n) _____ is a field that uniquely identifies each record.

Query optimization facilities are used to create backups just in case the database is damaged or lost.

What must you define before adding any information to a relational database?

XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

If you needed to store facts about information that you were collecting, you would store these facts in the _____.

_____ permit users to examine the impact of proposed structural changes on a database.

A(n) _____ can provide up-to-the-minute snapshots of any type of information and can often help you identify trends that may represent opportunities or that may be problems.

What is the type of field, or group of fields, that can uniquely identify each record in a database?

_____ is responsible for the more technical and operational aspects of managing the information contained in organizational databases.

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

The Information Age in Which You Live

Major Business Initiatives

Decision Support and Artificial Intelligence

Electronic Commerce

Systems Development

Enterprise Infrastructure, Metrics, and Business Continuity Planning

Protecting People and Information

Emerging Trends and Technologies

Filters

Exam 3: Databases and Data Warehouses

The objective of BI is to improve the timeliness and quality of the input to the decision making process.

What does it mean for a data warehouse to be multidimensional?

In an organization, _____ plans for, oversees the development of, and monitors the information resource.

_____ is a standardized fourth-generation query language found in most DBMSs.

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with?

A(n) _____ is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

Which type of environment allows you to go beyond operational database systems to support business intelligence?

A(n) _____ is a field that uniquely identifies each record.

Query optimization facilities are used to create backups just in case the database is damaged or lost.

What must you define before adding any information to a relational database?

XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

If you needed to store facts about information that you were collecting, you would store these facts in the _____.

_____ permit users to examine the impact of proposed structural changes on a database.

A(n) _____ can provide up-to-the-minute snapshots of any type of information and can often help you identify trends that may represent opportunities or that may be problems.

What is the type of field, or group of fields, that can uniquely identify each record in a database?

_____ is responsible for the more technical and operational aspects of managing the information contained in organizational databases.

If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

The Information Age in Which You Live

Major Business Initiatives

Decision Support and Artificial Intelligence

Electronic Commerce

Systems Development

Enterprise Infrastructure, Metrics, and Business Continuity Planning

Protecting People and Information

Emerging Trends and Technologies

Filters