Top 250+ Solved Data Mining and Business Intelligence MCQ Questions Answer
Q. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data insupport of management 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 datawarehouse is__________.
a. subject-oriented
b. time-variant
c. integrate
d. 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. __________describes the data contained in the data warehouse.
a. Relational data
b. Operational data
c. Metadata
d. Informational data
Q. __________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions.
a. Data warehouse
b. Data mining
c. Data marts
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. ___________defines the structure of the data held in operational databases and used byoperational applications.
a. User-level metadata
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 metadata
b. Algorithmic level metadata
c. Departmental level metadata
d. Core warehouse metadata
Q. __________maps the core warehouse metadata to business concepts, familiar and useful toend users.
a. Application level metadata
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 metadata
b. Transformation metadata
c. Historical metadata
d. Structural metadata
Q. ________consists of information in the enterprise that is not in classical form.
a. Mushy metadata
b. Differential metadata
c. Data warehouse
d. Data mining