FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Databases and Data Warehouses

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Essay

Review LaterAdd Note

Review Later

____________________ has become the query language of choice for many developers of relational DBMSs.

Correct Answer

verified

SQL
Structured Query...

View Answer

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Effective ____ and design of each database involves the creation of a conceptual blueprint of the database.

A) file modeling
B) file structuring
C) data modeling
D) data relating

E) C) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Because of capacity needs,organizations often choose ____ to store and manage data warehouses.

____ should first be done to decide which data should be collected and how it should be organized.

From a technical point of view,online databases that are used with Web browsers are different from other databases.

Databases are stored on and processed from ____ storage devices,such as magnetic disks or DVDs.

Organizations often organize their data warehouse as a collection of ____________________,smaller collections of data that focus on a particular subject or department.

To uncover the valuable information contained in their data,organizations must use software that can effectively "____" data warehouses.

Explain the impact of databases on businesses.

While a transactional database contains current data,which is disposed of after some time,the data in ____ is accumulated and might reflect many years of business activities.

Usually,a table in a relational database must have a primary key,and most relational DBMSs enforce this rule.

Once the data warehouse is in operation,much of the ETL activity can be automated.

What are the main features of maintenance of a relational database?

The impact of database technology on business can be easily overstated.

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the ____,which does have this mechanism.

A(n)____________________ creates a temporary table that is a subset of the original table or tables.

____ do not replace transactional databases,which are updated with daily transactions such as sales,billing,cash receipts,and returns.

Unlike ____________________,transactional databases are usually not suitable for business analysis because they contain only current,not historical,data.

The only way for organizations to conduct some Web-based businesses is to give people outside the organizations access to their ____________________.

To design a(n) ____,you need a clear idea of the different entities and how they relate.