Andhra University 2003 M.C.A DATA WARE HOUSING AND DATA MINING - Question Paper

M.C.A. DEGREE EXAMINATION-2003
Third Year
FIRST SEMESTER
ELECTIVE II: DATA WARE HOUSING AND DATA MINING
(Effective from the admitted batch of 2000 - 200 1)

Time: three Hours
Max. Marks: 75

First ques. is Compulsory.
ans any 4 form the remaining ques..
All ques. carry equal marks.
ans all parts of any ques. at 1 place.

1. Briefly explain
a) Data Warehouses
b) Data cleaning
c) Data Mining Primitives
d) Data Generalization
e) Ice berg query

2. a) Briefly discuss advanced Database Applications.

b) discuss functionalities of Data mining.

3. a) define any Data Ware House Architecture.

b) define development of Datacube Technology.

4. a) What is Data Mining Task? Write various approaches of data transformation.

b) discuss Analysis of Attribute Relevance.

5. a) explain the essential features of any Data mining Query Language.

b) discuss Mining single Dimensional Boolean Association Rules from Transactional Data bases with an illustration.

6. a) discuss why mining Descriptive statistical measures in large databases are needed.

b) explain constraint Based Association Mining.

7. Write an Algorithm for finding frequency item sets for Mining Multilevel Association Rules from Transactional Databases.

8. a) discuss Bayesian classification.

b) What is Cluster Analysis? Briefly explain about kinds of Data in Cluster Analysis.

Earning:   Approval pending.