M.Com. DEGREE EXAMINATION, APRIL 2018
Second Semester
Commerce with Computer Application
Elective — DATA MINING AND WAREHOUSING
(CBCS 2017 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is called Database heterogeneity?
2. What is meant by horizontal partitioning?
3. Explain about recovery in Data Warehousing.
4. What is the security in Data Warehousing?
5. What is called fixed queries in Data Warehousing?
6. Write about integration testing in Data Warehousing.
7. What is meant by concept formation?
8. What is fraud detection in Datamining?
9. Write about data cleaning.
10. What is called data selection?
Sub. Code
7MCC2E2
AFS-0536
2
WSS
Part B x 5 25)
Answer all questions, choosing either or
11. Write a short note on database scheme.
Or
How does meta data work?
12. Explain about hardware architecture.
Or
Write about physical layout.
13. Explain about capacity planning.
Or
Write about tuning and testing.
14. Explain about the marketing in data mining
Or
Differentiate between data mining and query tools.
15. What are the steps involved in visualization
techniques?
Or
Explain about Association rules.
AFS-0536
3
WSS
Part C x 10 30)
Answer any three questions.
16. Write a note on partitioning strategy.
17. Explain the steps by step process in Backup and
Recovery.
18. Explain about planning in Data warehouse.
19. Describe about self leaning computer system.
20. Explain briefly about OLAP tools.
————————