Total No. of Questions—5] [Total No. of Printed Pages—2
Seat
No. [5361]-54
M.C.A. (Commerce) (V-Semester) EXAMINATION, 2018
504 DATA WAREHOUSING AND DATA MINING
(2008 PATTERN)
Time Three Hours Maximum Marks 80
N.B. All questions are compulsory.
(ii Figures to the right indicate full marks.
(iii Neat diagram must be drawn wherever necessary.
1. Attempt any four of the following
What is B.I. Explain its purpose
What is multidimensional data model Why is it used in Data
warehousing
What is snowflake schema with diagram
What are the social implications of data mining
Write a note on backup and recovery in data warehousing.
2. Attempt any four of the following
What is temporal mining Why is it used
Discuss the issue of data mining system.
What is web usage mining
Describe different types of server.
Explain hardware architecture of data warehouse.
[5361]-54 2
3. Attempt any two of the following
Explain star schema with example and diagram.
Explain KDD process and draw a diagram.
Solve the following example of single level association rule,
with minimum support as 2
Transaction ID Items
T1 H
T2 S
T3 G
T4 H
T5 G
T6 O
4. Attempt any two of the following
Explain the method that mines the complete set of frequent
itemsets without candidate generalization.
Explain outlier analysis and types of outlier analysis.
What is knowledge base Explain any 5 data mining technique.
5. Attempt any four of the following
Data Integration
Decision Tree
Prediction
Multidimensional cube
Aggregation of Data.