GTU last year question papers -BE- Sem-VIIth -Data warehousing and Data Mining -May/June- 2012

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

Instructions:

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

Discovery Process.  

(b) What is Cuboid? Explain various OLAP Operations on Data Cube with example.  

Q.2 (a) Explain following Terms:

1. Concept Hierarchy.

2. Histogram.  

(b) Explain Mean, Median, Mode, Variance & Standard Deviation in brief.    

OR

(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.  

OR

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.

OR

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.    

OR

Q.5 (a) Explain different types of data on which mining can be performed.    

(b) Explain Rule-based Classification in brief.    

 

Leave a Comment