Sample Paper for Integrated MCA in Data Mining & Warehousing 4th year
INTEGRATED MCA IN DATA MINING & WAREHOUSING
SEMESTER-VIII/YEAR – 4
Time -3 hours Max Marks: 100
Note: 1. Attempt any five questions.
2. All question carry equal marks.
Q1. (a) What do you understand by data warehouse? What are the characteristics of Data
(b) List some advantages of data warehouse?
Q2. Explain structure of the data warehouse? Discuss in detail all the steps involved in making a data warehouse?
Q3. (a) Explain OLTP and OLAP and also discuss differences between them?
(b) It is always said that the data warehouse should be built separate. Justify?
Q4. (a) Draw and explain any two models of data warehouse?
(b) Draw and explain 4-dimensional data cube with an example?
Q5. Explain the following terms;
i. Project Estimation
ii. Analyzing Probability and Risk
iii. Managing Risk
iv. Return on Investment
Q6. (a) What is Data mining (DM)? Define and describe relationship and patterns detected in data mining. What is the scope of data mining?
(b) Explain cluster analysis?
Q7. Explain the following stages used in data preprocessing for data mining;
- i. Data selection
- ii. Data cleaning
- iii. Date reduction
- iv. Data enrichment
- v. Pattern evaluation
Q8. Explain MOLAP and ROLAP? Explain the following OLAP operations in the multidimensional data model with the diagram and an example (20)
- i. Dice for
- ii. Slice for
- iii. Drill down
- iv. Roll up
- v. Pivot
Q9. (a) Is it necessary that every small or big company should have a data warehouse? Justify your answer?
(b) Explain the three-tier data warehouse architecture? (14)
Note: Above Sample Paper for Integrated MCA in Data Mining & Warehousing 4th year has been prepared after reviewing few universities sample papers. We are not sure whether same or similar question papers pattern does your university has or not. We are just trying to help you by providing the possibilities. We always suggest you to go thoroughly with textbooks, teacher’s notes and the syllabus for better preparation of your coming examination.