Data WareHousing and Data Mining Mid - I, September - 2014

1.Extracting knowledge from large amount of data is called ____________________.
  • Warehousing
  • data mining
  • database
  • cluster
Answer: B
2.Data warehouses and OLAP tools are based on a __________ dimensional data model.
  • single
  • multi
  • three
  • cube
Answer: B
3.The querying of multidimensional databases can be based on a ______________ model.
  • Star net
  • data
  • query
  • none
Answer: A
4.A HOLAP server combines _____________ .
  • ROLAP
  • MOLAP
  • a & b
  • none
Answer: C
5.Star schema consists of ____________& _______________ tables.
  • fact, dimension
  • dimension, star
  • a& b
  • none
Answer: A
6.___________Operation performs a selection on one dimension of the given cube.
  • slice
  • dice
  • pivot
  • none
Answer: A
7.The data warehouse can be built by using __________ approach.
  • Top-down
  • bottom-up
  • both a & b
  • none
Answer: C
8.Users of data mining systems can be classified into____________ categories.
  • 1
  • 2
  • 3
  • 4
Answer: D
9.Data base size is 100 GB to TB in
  • OLTP
  • OLAP
  • both a & b
  • none
Answer: B
10.Smoothing techniques are ________________
  • binning
  • aggregation
  • Normalization
  • None
Answer: A
11._____________ refers to the computation of all the cuboids in the lattice.
Answer: Full Materialization
12.IQR stands for___________________________.
Answer: Inter Quartive Range
13.AOI stands for __________________________.
Answer: Attribute Orientation Induction
14.The measures of pattern interestingness asses the ________,_________,_________,__________ of discovered patterns.
Answer: Simplicity, Certainty, Utility, Novelty
15.A ______________ allows data to be modeled and viewed in multiple dimensions.
Answer: Data cube
16.______________ is task of discovering interesting patterns from large amounts of data.
Answer: Data Mining
17._______________ data marts are sources directly from enterprise data warehouse.
Answer: Dependent
18._____________contains a subset of corporate –wide data that is of value to a specific group of users.
Answer: Data mart
19.________________ converts data from legacy or host format to warehouse format.
Answer: Data Transmission
20._________________ is the estimate of the strength of the implication of the rule.
Answer: Confidence