Top 350+ Solved Data Mining and Data Warehouse MCQ Questions Answer
Q. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support ofmanagement decisions.
a. data mining.
b. data warehousing.
c. web mining.
d. text mining.
Q. Expansion for DSS in DW is__________.
a. decision support system.
b. decision single system.
c. data storable system.
d. data support system.
Q. The important aspect of the data warehouse environment is that data found within the data warehouseis___________.
a. subject-oriented.
b. time-variant.
c. integrated.
d. all of the above.
Q. The time horizon in Data warehouse is usually __________.
a. 1-2 years.
b. 3-4years.
c. 5-6 years.
d. 5-10 years.
Q. ____________predicts future trends & behaviors, allowing business managers to make proactive,knowledge-driven decisions.
a. data warehouse.
b. data mining.
c. datamarts.
d. metadata.
Q. __________ is the heart of the warehouse.
a. data mining database servers.
b. data warehouse database servers.
c. data mart database servers.
d. relational data base servers.
Q. ________________ is the specialized data warehouse database.
a. oracle.
b. dbz.
c. informix.
d. redbrick.
Q. ________________defines the structure of the data held in operational databases and used byoperational applications.
a. user-level metadat
b. data warehouse metadata.
c. operational metadata.
d. data mining metadata.
Q. ________________ is held in the catalog of the warehouse database system.
a. application level metadat
b. algorithmic level metadata.
c. departmental level metadata.
d. core warehouse metadata.
Q. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.
a. application level metadat
b. user level metadata.
c. enduser level metadata.
d. core level metadata.
Q. ______consists of formal definitions, such as a COBOL layout or a database schema.
a. classical metadat
b. transformation metadata.
c. historical metadata.
d. structural metadata.
Q. _____________consists of information in the enterprise that is not in classical form.
a. mushy metadat
b. differential metadata.
c. data warehouse.
d. data mining.
Q. . ______________databases are owned by particular departments or business groups.
a. informational.
b. operational.
c. both informational and operational.
d. flat.