Master of Computer Application II (Computer Science)
Examination: Oct/Nov 2016 Semester IV (New CGPA)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR U
-27
Saturday
19/11/2016
02.30 PM
to
05.00 PM
Data Mining and
Warehouse
C

Instructions: Question no. 1 2 are compulsory
Attempt any three questions from Q. No. 3 to Q. No. 7
Figures to the right indicate full marks.
Total Marks: 70
Q.1 Choose correct alternatives 10
Classification rules are extracted from
root node decision tree
siblings branches
Data compression is to compress the given data by encoding in terms of

bytes bits
cluster group
Which of the following table type belongs to snowflake schema?
free dimension
replicator double
Fact tables are
completely demoralized partially demoralized
completely normalized partially normalized
The types of relationships in star schema is
many-to-many one-to-one
one-to-many many-to-one
Which of the following is true?
The data warehouse
consists of data marts and
operational data
The data warehouse consists
of data marts and
application data.
The data warehouse is used
as a source for the
operational data.
The operational data are
used as a source for the data
warehouse
is the first stage in KDD process.
data selection cleaning
mining Enrichment
The operation is used for reducing data cube by one or more
dimensions.
Drilling Rolling
Dicing Slicing
Page 1 of 2
A acts a bride between data warehouse and database
applications.
data mart operational data
meta data data cube
10)A data warehouse is an integrated collection of data because
it is a collection of data
of different data types
it is a collection of data derived
from multiple sources
it is a relational
database
it contains summarized data
State true or false 04
A data warehouse is said to contain a time-varying collection of data
because it contains historical data.
A volatile is not the rule that govern the basic structure of data
warehouse.
The client/server represents the best choice for building a data
warehouse.
The transactional data are stored in data warehouse.
Q.2 write a short notes on
Snowflake Schema model
Star Schema model
08
Answer the following 06
What is data cube?
Write a note on fact constellation schema model.
Q.3 Answer the following
Explain data mining primitives.
Explain K Means algorithm with example.
06
08
Q.4 Answer the followings
Explain outlier analysis
Explain data preprocessing.
06
08
Q.5 Answer the followings
Explain Data Mining Query Language (DMQL).
Data mining as a step in the process of KDD. Explain.
06
08
Q.6 Answer the following 14
Differentiate between OLAP and OLTP
What are the attributes selection measures in classification?.
Q.7 Answer the following 14
Explain agglomerative and divisive hierarchical method of clustering.
Write a note on data warehousing back end tools.
Page 2 of 2