MIS Final Exam

because of the various problems with operational data, large organizations choose to extract operational data and store them into a ______________ a. olap cube b.

data warehouse

which of the following is used to modify the structure (metadata, data dictionary) of a table?

design view

Major objects in an Access database include the following

forms, queries, reports, and tables

A data ________ is a data collection, smaller than the data warehouse, that addresses the needs of a particular department or functional area of the business.

mart

RFM analysis is used to analyze and rank customers according to their _____.

motivation and needs

which of the following data types automatically generates a consecutive number?

number

___ is a term that came to be used when companies such as Google offered thin-client email such as Gmail for free, as a service

software as service

which of the following is a valid observation of MYSQL? a) it is offered by oracle b) it is licensed free for most applications c) it is closed source database product d)it is yet to be widely adopted

b. it is licensed free for most applications

The forked lines on the right side of a line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as ________.

crows feet