Exam 3: Databases and Data Warehouses: Building Business

A(n)_____ uniquely identifies each record.

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

The data definition subsystem includes security management facilities.

Report generators help you quickly define formats of reports and what information you want to see in a report.

What is the difference between multidimensional analysis and statistical analysis?

A(n)_____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

If your student information had two different birth dates for you,your data would not be considered _____.

Because data warehouses are not transaction-oriented,they only support _____.

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

Online analytical processing (OLAP)is the gathering of input information,processing that information,and updating existing information to reflect the gathered and processed information.

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

A database consists of _____ and a(n)_____.

Data warehouses always uses 2D tables to store data.

Operational databases are databases that support OLAP.

A(n)_____ defines formats of reports and what information you want to see in a report.

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

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

A(n)_____ subsystem contains facilities for concurrency control.

Data warehouses support transaction processing.

Which of the following terms represent an organized and structured collection of information?