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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) data administration.
B) database administration.
C) information policy administration.
D) data auditing.

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

Multiple Choice

Review LaterAdd Note

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

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

________ is where the same attribute may have different values.

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 select,join,and project operations enable data from two different tables to be combined and only selected attributes to be displayed.

The most prominent data manipulation language today is ________.

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

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

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

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

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

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.

A data warehouse may be updated by a legacy system.

Microsoft Access is a relational DBMS for desktop systems.

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

The join operation

A DBMS makes the

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