Sample Paper for B.Sc Information Technology for 3rd year Data Warehousing & Data Mining
B.SC INFORMATION TECHNOLOGY SEMESTER-VI, YEAR- 3
DATA WAREHOUSING AND DATA MINING
Duration -3 Hrs Max Marks: 100
Note: 1. Attempt any five questions.
2. All question carry equal marks.
Q1. What do you understand by data warehouse? What are the characteristics of Data Warehousing?
Q2. Explain structure of the data warehouse? Discuss in detail all the steps involved in making a data warehouse?
Q3. It is always said that the data warehouse should be built separate. Justify?
Q4. Draw and explain any two models of data warehouse?
Q5. Explain the following terms;
- i. Project Estimation
- ii. Analyzing Probability and Risk
Q6. What is Data mining (DM)? Define and describe relationship and patterns detected in data mining. What is the scope of data mining?
Q7. Explain the following stages used in data preprocessing for data mining;
- i. Data selection
- ii. Data cleaning
Q8. Explain MOLAP and ROLAP? Explain the following OLAP operations in the multidimensional data model with the diagram and an example
- i. Dice for
- ii. Slice for
Q9. Is it necessary that every small or big company should have a data warehouse? Justify your answer?
Note: Above Sample Paper for B.Sc Information Technology for 3rd year Data Warehousing & Data Mining 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.
All the Best!!