JNTU
JNTU MCA 2019 DATA WAREHOUSING AND DATAMINING Previous Question Paper (April/May - 2019 - R17)
Note: This question paper contains two parts A and B. Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit.
PART - A
What is a pattern? What are the characteristics of an interesting pattern?
Answer
A pattern is a regularity, structure, or relationship discovered within a data set that provides meaningful information or insight. An interesting pattern is defined by the following characteristics: it is easily understood by humans, valid on new data with some degree of certainty, potentially useful, and novel (not previously known). Furthermore, interesting patterns often possess a high degree of utility or provide actionable intelligence for decision-making.
Compare and contrast database management system with data warehouse.
Answer
| Feature | DBMS (OLTP) | Data Warehouse (OLAP) |
|---|---|---|
| Purpose | Day-to-day operations | Decision support and analysis |
| Data State | Current, detailed | Historical, summarized |
| Query Type | Simple, frequent updates | Complex, read-intensive |
| Design | Normalized (ER models) | Denormalized (Star/Snowflake) |
DBMS systems are optimized for transactional integrity and concurrency control, whereas data warehouses are optimized for high-performance analytical querying across large historical datasets.
What characteristics of neural networks make them good classifiers?
Answer
Sign in to view the complete answer paper.
Give the advantages and disadvantages of partition based methods for clustering.
Answer
Sign in to view the complete answer paper.
Provide examples for spatial and non-spatial data in database.
Answer
Sign in to view the complete answer paper.
PART - B
What is the need of preprocessing of data for mining? Briefly explain various forms of preprocessing.
Answer
Sign in to view the complete answer paper.
Discuss the major issues pertaining to mining methodology and user interaction in data mining.
Answer
Sign in to view the complete answer paper.
Illustrate online analytical processing operations.
Answer
Sign in to view the complete answer paper.
Demonstrate the working of BUC algorithm for data cube computation.
Answer
Sign in to view the complete answer paper.
What are the limitations of Apriori algorithm? Suggest mechanisms to improve the accuracy of Apriori algorithm.
Answer
Sign in to view the complete answer paper.
Consider the following data and classify the new sample X= < youth, medium, yes, fair> using Naïve Bayesian classification.
Answer
Sign in to view the complete answer paper.
What is Є- neighbourhood in density based methods?
Answer
Sign in to view the complete answer paper.
List the challenges raised by high dimensional data for clustering.
Answer
Sign in to view the complete answer paper.
Write BIRCH algorithm. Does BIRCH follow agglomerative nesting? Justify your answer.
Answer
Sign in to view the complete answer paper.
What is the importance of sequence mining? Explain Prefix Span algorithm for sequence mining.
Answer
Sign in to view the complete answer paper.
Demonstrate Latent semantic indexing for text mining with simple example text corpus.
Answer
Sign in to view the complete answer paper.