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]

UNIVERSITY OF PUNE

[4364-296]

B.E.(Computer Engineering) Examination 2013

Advanced Databases

(2003 pattern)

Time-Three hours                                                             Maximum Marks-100

Instructions:

(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.

SECTION-I

Q.1 (a) Describe and differentiate the following partitioning techniques. (8)

(i) RangePartitioning (ii) Round Robin

(b) Explain the following with suitable example. (8)

(i) Pipelinedparallelism (ii) Independent parallelism

OR

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

(c) What is meant by skew in Parallel databases? (2)

Q.3 (a) Explain in detail Deadlock Handling and availability with respect to distributeddatabases. (10)

(b) Explain distributed data storage. (8)

OR

Q.4 (a) What are different locking protocols in distributed databases ? Explain. (10)

(b) Explain data fragmentation in distributed databases. (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)

OR

Q.6 (a) Explain the following terms. (6)

(i) Thin client (ii) Xpath (iii) Application server

(b) Explain in detail XML document. (10)

SECTION-II

Q.7 (a) Differentiate between OLTP and OLAP systems. (6)

(b) Explain in detail snowflake schema for the multidimensional databases. (10)

OR

Q.8 (a) Why data pre-processing is required? Explain phases of Data Pre-processing.

(10)

(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

OR

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

OR

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

************************