Advanced Database Management System - Tutorials and Notes: Advanced Database Question Pune University - 2013

Friday, 15 August 2014

Advanced Database Question Pune University - 2013

Pune University BE(CSE) Question Papers / Previous year BE(Computer Engg.) question papers of Pune University / BE CSE Advanced Databases Question Paper / Pune University Questions with Answers - Regulation 2003

[Click on the links to view answers]

[Total No. of Question=12]                                    [Total no. of printed pages= 3]
B.E.(Computer Engineering) Examination 2013
Advanced Databases
(2003 pattern)
Time-Three hours                                                             Maximum Marks-100
(1)Answer to the TWO sections should be written in separate answer books
(2)Neat diagrams must be drawn whenever necessary.
(3)Figures to the right indicate full marks.
(4)Assume suitable data whenever necessary.


Q.1 (a) Describe and differentiate the following partitioning techniques. (8)
(b) Explain the following with suitable example. (8)
Q.2 (a) Explain in detail intraoperation and interoperating parallelism. (8)
(b) Describe how following operations are parallelized. (6)
(i) Selection (ii) Projection (iii) Aggregation

(b) Explain distributed data storage. (8)

Q.5 (a) Explain the following terms. (6)
(i) SOAP (ii) X -query (iii) XML DTD
(b) Explain in detail different tiers in 3-tier architecture. (10)
Q.6 (a) Explain the following terms. (6)
(i) Thin client (ii) Xpath (iii) Application server
(b) Explain in detail XML document. (10)


Q.7 (a) Differentiate between OLTP and OLAP systems. (6)
(b) Explain in detail snowflake schema for the multidimensional databases. (10)
Q.8 (a) Why data pre-processing is required? Explain phases of Data Pre-processing.
(b) Explain the following terms. (6)
(i) Data cube (ii) Slice and dice.

Q.9 (a) State and explain K-means Algorithm. (10)
(b) Write short note on. (8)
(i) Decision tree (ii) Outlier analysis
Q.10 (a) State and Explain Apriori Algorithm. (10)
(b) Write short notes on. (8)
(i) Bayesian classifier (ii) Text Mining
Q.11 (a) Describe web crawler and web search engine in detail. (8)
(b) Explain the following terms. (8)
(i) Inverse document frequency
(ii) Homonyms
(iii) Synonyms
(iv) Term frequency
Q.12 (a) Explain in detail popularity ranking. (8)
(b) Explain the following terms. (8)
(i) Inverted Index
(ii) Precision and recall
(iii) Stop words
(iv) Ontologies


Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents