FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Databases and Information Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

True/False

Review LaterAdd Note

Review Later

Each characteristic or quality describing a particular entity is called an attribute.

Correct Answer

verified

Show Answer

Question 62

True/False

Review LaterAdd Note

Review Later

Unlike structured data,which are generated from events such as completing a purchase transaction,unstructured data have no distinct form.

Correct Answer

verified

Show Answer

Question 63

Short Answer

Review LaterAdd Note

A data warehouse system also provides a range of ad hoc and standardized query tools,________ tools,and graphical reporting facilities.

The join operation

The special organizational function whose responsibilities include the technical and operational aspects of managing data,including physical database design and maintenance,is called

________ are applications and technologies to help users make better business decisions.

A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because

Jill started a paint store 12 years ago.She put in a traditional file system to meet her marketing needs when she started her business.Two years later she put in a traditional file system to take care of accounting and operations.Just three years ago they put in another system to handle marketing and CRM.Jill is looking at installing another traditional file system this year to handle purchasing and SCM.Jill has been reading that perhaps they should be using a DBMS instead of these individual traditional file systems.How would you advise her and why?

The type of logical database model that treats data as if they were stored in two-dimensional tables is the

________ is where the same attribute may have different values.

Databases record information about general categories of information referred to as ________.

A DBMS makes the

Microsoft Access is a relational DBMS for desktop systems.

The most prominent data manipulation language today is ________.

In a relational database,complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

The select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

OLAP enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

________ are the formal rules governing the maintenance,distribution,and use of information in an organization.

A data warehouse may be updated by a legacy system.

Common Gateway Interface is a specification for processing data on a Web server.