Top 350+ Solved Data Mining and Data Warehouse MCQ Questions Answer
Q. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in supportof management decisions.
a. data mining.
b. data warehousing.
c. web mining.
d. text mining.
Q. The important aspect of the data warehouse environment is that data found within the datawarehouse is___________.
a. subject-oriented.
b. time-variant.
c. integrated.
d. all of the above.
Q. _________maps the core warehouse metadata to business concepts, familiar and useful to endusers.
a. application level metadat
b. user level metadata.
c. enduser level metadata.
d. core level metadata.
Q. Data redundancy between the environments results in less than ____________percent.
a. one.
b. two.
c. three.
d. four.
Q. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumedin the conversion process.
a. 10 percent.
b. 20 percent.
c. 40 percent
d. 80 percent.
Q. The biggest drawback of the level indicator in the classic star-schema is that it limits_________
a. quantify.
b. qualify.
c. flexibility.
d. ability.
Q. Maintenance of cache consistency is the limitation of __________________.
a. num
b. unam.
c. mpp.
d. pmp.
Q. ___________ of data means that the attributes within a given entity are fully dependent on theentire primary key of the entity.
a. additivity.
b. granularity.
c. functional dependency.
d. dimensionality.
Q. Non-additive measures can often combined with additive measures to create new _________..
a. additive measures.
b. non-additive measures.
c. partially additive.
d. all of the above.
Q. ____________ of data means that the attributes within a given entity are fully dependent on theentire primary key of the entity.
a. additivity.
b. granularity.
c. functional dependency.
d. dependency.
Q. _____________ helps to uncover hidden information about the data..
a. induction.
b. compression.
c. approximation.
d. summarization.
Q. The _______ step eliminates the extensions of (k-1)-itemsets which are not found to be frequent,from being considered for counting support.
a. candidate generation.
b. pruning.
c. partitioning.
d. itemset eliminations.
Q. The transformed prefix paths of a node 'a' form a truncated database of pattern which co-occurwith a is called _______.
a. suffix path.
b. fp-tree.
c. conditional pattern base.
d. prefix path.