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

A _____ is a collection of information that you organize and access according to the logical structure of that information.

_____ are the technology tools that directly support OLTP.

_____ refers to collective information that gives you the ability to make effective,important,and often strategic business decisions.

Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

A(n)_____ contains the logical structure for the information contained within a database.

A data warehouse is:

_____ and _____ both extract data meeting specific criteria from a database,but have different user interfaces.

_____ is the function in an organization that plans for,oversees the development of,and monitors the information resource.

Who,among the following,is responsible for overseeing the underlying IT infrastructure within an organization?

What is the most popular model for creating databases?

Data warehouses always use two-dimensional tables to store data.

When you create a database,you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

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

A database management system contains five important software components.Which of the following components allows you to create and maintain the data dictionary?

The DBMS _____ accepts logical requests from the various other DBMS subsystems,converts them into their physical equivalent,and actually accesses the database and data dictionary as they exist on a storage device.

Multidimensional analysis (MDA)tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

_____ is responsible for the development and use of firewalls,intranets,extranets,and anti-virus software.

Databases that support OLTP are most often referred to as ____.

_____ is the gathering of input information,processing that information,and updating existing information to reflect the gathered and processed information.

If you were viewing information from different perspectives in a multidimensional analysis,you would be ____.