Master of Science II (Computer Science)
Examination: Oct Nov 2016 Semester IV Old CGPA)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR SC-
329
Saturday
19/11/2016
2:30 P.M
to
5:00 P.M
Data mining And
Warehouse
C
XIV
Instructions: Questions No.1 and 2 are compulsory
Attempt any 3 questions from Q.No.3 to Q. No. 7.
Figures to the right indicate full marks.
Q.1
Choose the correct alternative given in the bracket. 10
is a subject-oriented, integrated, time-variant, nonvolatile
collection of data in support of management decision.
Data mining Data Warehousing
Web mining Text mining
supports basic OLAP operations, including slice and dice,
drill-down, roll-up and pivoting.
Information processing Data mining
Analytical processing Transaction processing
The schema is a variant of the star schema model, where some
dimensions are normalized, thereby further splitting the data into a
additional tables.
Star schema Snowflake
Fact constellation None of these
The cuboid that holds the lowest level of summarization is called the
cuboid.
Base Apex
Lowest None of these
Classification rules are extracted from
Root node Sibling
Branches Decision tree
A feed forward neural network consists of an input layer, one or
more hidden layers, and an output layer.
Multilayer Single layer
One layer None of these
The also called the bottom up approach.
Density based Divisive approach
Agglomerative approach None of these
The operation performs a selection on one dimension of the
given cube, resulting in a subcube.
Drill-down Drill-up
Dicing Slicing
Page 1 of 2
Discovery of cross-sales opportunities is called
Visualization Association
Correction Segmentation
10) means that a DM system will use some facilities of a DB or
DW system, fetching data from a data repository managed by this system.
Loose coupling Semi-tight coupling
Tight coupling No-coupling
State either True/ False 04
A data mining query is defined in terms of data mining task primitives.
A binning method smooth a random data value by consulting its
"neighborhood", that is the values around it.
The term soil refers to the size of soil particles and their
arrangement, that is, the values around it.
An OLAP system usually adopts an Entity relationship data model.
A fact constellation schema allows dimension tables o shared between
fact tables.
Q.2 Write a short notes on the following: 08
Data warehouse Back-End Tools and Utilities.
Task relevant data
Answer the following questions: 06
Explain the terms support and confidence in interestingness primitive.
Explain the importance of data mining query language.
Q.3 Answer the following: 14
What is data cube? Explain various types of data cube representation form
with example.
What are different kinds of data mining primitives? Explain each with
example.
Q.4 Answer the following: 14
How association rules are generated from large databases? Explain it.
Describe issues regarding preprocessing the data for classification and
prediction.
Q.5 Answer the following: 14
Explain the basic algorithm for decision tree induction method with example.
What is Cluster Analysis? Explain basic requirements of clustering in data
mining.
Q.6 Answer the following: 14
Explain the steps in K-means algorithm
Describe three tier Data warehouse architecture with well labeled diagram.
Q.7 Answer the following: 14
Explain recent trends in data mining.
How data mining is useful for Telecommunication Industries.