Question 1

What is a digital dashboard?

Accepted Answer

A) A new type of electronic dashboard for high-priced cars that displays GPS information alongside of traditional information 
B) A learning environment for online educational courses 
C) A computer tool that provides competitive information from external sources 
D) A computer screen that provides tailored,current snapshots of information and trends 
A) A new type of electronic dashboard for high-priced cars that displays GPS information alongside of traditional information 
B) A learning environment for online educational courses 
C) A computer tool that provides competitive information from external sources 
D) A computer screen that provides tailored,current snapshots of information and trends

Question 2

Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives?

Accepted Answer

A) Query-and-reporting 
B) Intelligent agents 
C) OLTP 
D) Multidimensional analysis 
A) Query-and-reporting 
B) Intelligent agents 
C) OLTP 
D) Multidimensional analysis

Question 3

There can be duplicate primary keys in the same file in a database.

Accepted Answer

A) True 
 B)False

Question 4

Which data manipulation tool allows you to graphically design the answer to your business questions?

Accepted Answer

A) Report generators 
B) Application reports 
C) Query-by-example tools 
D) Data administration tools 
A) Report generators 
B) Application reports 
C) Query-by-example tools 
D) Data administration tools

Question 5

Data-mining tools support the concept of OLTP in manipulating information to support decisions.

Accepted Answer

A) True 
 B)False

Question 6

A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

Accepted Answer

A) True 
 B)False

Question 7

A(n)_____ contains the logical structure for the information.

Accepted Answer

The answer of A(n)_____ contains the logical structure for the...

Question 8

Which organizational function is responsible for developing security procedures for an organization?

Accepted Answer

A) Data security 
B) Data protection 
C) Information resource management 
D) Database administration 
A) Data security 
B) Data protection 
C) Information resource management 
D) Database administration

Question 9

A data warehouse 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

A) True 
 B)False

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) Relational DBMS 
D) Data warehouses 
A) Transactional systems 
B) Application generators 
C) Relational DBMS 
D) Data warehouses

Question 11

A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information.

Accepted Answer

A) Accountability 
B) Information ownership 
C) Data security 
D) Data management and control 
A) Accountability 
B) Information ownership 
C) Data security 
D) Data management and control

Question 12

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Accepted Answer

A) True 
 B)False

Question 13

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.

Accepted Answer

A) True 
 B)False

Question 14

What is the difference between data administration and database administration?

Accepted Answer

A) Data administration focuses on strategic management whereas database administration focuses on operational issues 
B) Data administration focuses on OLTP whereas database administration focuses on OLAP 
C) Data administration and database administration are terms that can be used interchangeably 
D) Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data 
A) Data administration focuses on strategic management whereas database administration focuses on operational issues 
B) Data administration focuses on OLTP whereas database administration focuses on OLAP 
C) Data administration and database administration are terms that can be used interchangeably 
D) Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data

Question 15

A(n)_____ represents how users see information to meet their particular business needs.

Accepted Answer

The answer of A(n)_____ represents how users see information to...

Question 16

In a data warehouse,which tool would you use to build reports quickly and without having to write programming code?

Accepted Answer

A) Application generator 
B) Intelligent agents 
C) Multidimensional analysis tools 
D) Query-and-reporting tools 
A) Application generator 
B) Intelligent agents 
C) Multidimensional analysis tools 
D) Query-and-reporting tools

Question 17

A(n)_____ represents how data is physically stored on a storage device.

Accepted Answer

The answer of A(n)_____ represents how data is physically stored...

Question 18

The _____ helps you add,change,and delete information in a database and mine it for valuable information.

Accepted Answer

Data manip

Question 19

A primary key field cannot be _____.

Accepted Answer

The answer of A primary key field cannot be _____....

Question 20

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

Accepted Answer

A) True 
 B)False

What is a digital dashboard?

Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives?

There can be duplicate primary keys in the same file in a database.

Which data manipulation tool allows you to graphically design the answer to your business questions?

Data-mining tools support the concept of OLTP in manipulating information to support decisions.

A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A(n)_____ contains the logical structure for the information.

Which organizational function is responsible for developing security procedures for an organization?

A data warehouse 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 environment allows you to go beyond operational database systems to support business intelligence?

A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information.

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.

What is the difference between data administration and database administration?

A(n)_____ represents how users see information to meet their particular business needs.

In a data warehouse,which tool would you use to build reports quickly and without having to write programming code?

A(n)_____ represents how data is physically stored on a storage device.

The _____ helps you add,change,and delete information in a database and mine it for valuable information.

A primary key field cannot be _____.

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

The Information Age in Which You Live: Changing

Major Business Initiatives: Gaining Competitive

Decision Support and Artificial Intelligence

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Enterprise Infrastructure, Metrics, and Business

Protecting People and Information

Emerging Trends and Technology

Computer Hardware and Software

Network Basics

Careers in Business

Filters

Exam 3: Databases and Data Warehouses: Building Business

What is a digital dashboard?

Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives?

There can be duplicate primary keys in the same file in a database.

Which data manipulation tool allows you to graphically design the answer to your business questions?

Data-mining tools support the concept of OLTP in manipulating information to support decisions.

A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

A(n)_____ contains the logical structure for the information.

Which organizational function is responsible for developing security procedures for an organization?

A data warehouse 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 environment allows you to go beyond operational database systems to support business intelligence?

A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information.

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.

What is the difference between data administration and database administration?

A(n)_____ represents how users see information to meet their particular business needs.

In a data warehouse,which tool would you use to build reports quickly and without having to write programming code?

A(n)_____ represents how data is physically stored on a storage device.

The _____ helps you add,change,and delete information in a database and mine it for valuable information.

A primary key field cannot be _____.

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

The Information Age in Which You Live: Changing

Major Business Initiatives: Gaining Competitive

Decision Support and Artificial Intelligence

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Enterprise Infrastructure, Metrics, and Business

Protecting People and Information

Emerging Trends and Technology

Computer Hardware and Software

Network Basics

Careers in Business

Filters