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

A(n)_____ allows you to specify the logical organization for a database and access and use the information within a database.

A report generator allows you to see the contents of a database file,make whatever changes you want,perform simple sorting,and query to find the location of specific information.

Which part of a relational database contains the logical structure for the information?

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

Databases and DBMSs are the technology tools that directly support OLAP.

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information,you are actively engaging in analytics.

QBEs rely heavily on the physical relationships within a database to find information.

Which term refers to a specific piece of information that is stored in a database file?

_____ facilities find the "shortest route" to the information you want so you don't have to.

Information sharing in your organization means that anyone can access and use whatever information he or she needs.

If you were to perform a regression analysis,what type of data warehouse tool would it be?

What is the difference between multidimensional analysis and statistical analysis?

What term is used to describe the use and distribution of information regardless of title or department?

_____ is the process of reinstalling the backup information in the event the information was lost.

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.

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

_____ is responsible for overseeing every aspect of an organization's information resource.

The DBMS engine can process virtually any logical information view or request into its physical equivalent.

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

_____ focuses on the integrated use of technology tools and statistical techniques to create real-time,high-quality,fact based business intelligence in support of decision making.