Exam 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

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

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

A(n)_____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

Which database management subsystem is responsible for backup and recovery,security management,query optimization,concurrency control,and change management?

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

A _____ is simply a copy of the information stored on a computer.

A foreign key is also a primary key.

Which data manipulation tool allows you to see the contents of a database file and make whatever changes you want?

Data warehouses exist to support:

When you create a database,you first create its data dictionary.

The physical view of information focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Application generation facilities are most often used by operations personnel.

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

If your phone number was used in a clothing store to uniquely identify you as a customer,the phone number would be considered a(n)____.

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

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

The _____ subsystem of a DBMS helps you create and maintain the data dictionary and define the structure of the files in a database.

Which type of application requires that you know the physical location of information before you are able to access it?

If you were comparing information from various divisions of an organization such as sales,marketing,and production,what type of information repository would you be most likely working with?