GTU last year question papers
GUJARAT TECHNOLOGICAL UNIVERSITY
BE- VIIth SEMESTER–EXAMINATION – MAY/JUNE- 2012
Subject code: 171601
Subject Name: Data Warehousing and Data Mining
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (a) What is Data Mining? Explain Data mining as one step of Knowledge
(b) What is Cuboid? Explain various OLAP Operations on Data Cube with example.
Q.2 (a) Explain following Terms:
1. Concept Hierarchy.
(b) Explain Mean, Median, Mode, Variance & Standard Deviation in brief.
(b) Explain Information Gain, Gain Ratio & Gini Index.
Q.3 (a) Compare OLTP & OLAP systems.
(b) Explain Star, Snowflake, Fact Constellation Schema for Multidimensional Database.
Q.3 (a) Explain BUC algorithm for the Computation of Sparse or Iceberg Cube.
(b) Explain the Classification by Decision Tree Induction Algorithm.
Q.4 (a) Write & Explain Apriori algorithm for discovering frequent itemsets for
mining Boolean Association Rules.
(b) What is Market Basket Analysis? Explain Association Rules with
Confidence & Support.
Q.4 (a) Explain Linear & Non-Linear Regression methods of Predictions.
(b) Explain k-means and k-medoids algorithm of clustering.
Q.5 (a) Explain Data Cleaning process for missing values & Noisy data.
(b) Explain different types of Web Mining with example.
Q.5 (a) Explain different types of data on which mining can be performed.
(b) Explain Rule-based Classification in brief.