Advanced databases - BE-CSE - Pune University Questions April May 2014

Pune University BE(CSE) Question Papers May June 2014 - 2008 Pattern / Previous year BE(Computer Science Engineering) question papers of Pune University / BE CSE Advanced Databases Question Paper / Pune University Questions with Answers

UNIVERSITY OF PUNE

B. E. (CSE) Examination - 2014

ADVANCED DATABASES

(2008 Pattern)

[Time : 3 Hours]                                                                [Max. Marks : 100]

[Total No. of Questions : 12]                                     [Total No. of Printed Pages :3]

Instructions :

(1) Answers to the section should be written in separate books

(2) Neat diagrams must be drawn wherever necessary.

(3) Assume suitable data, if necessary.

(4) Section I :Q1or Q2, Q3 or Q4, Q5 or Q6

(5) Section II: Q7 or Q8, Q9 or Q10, Q11 or Q12

SECTION-I

Q1) a) Compare the Round-robin and Range partitioning Techniques. [8]

b) Explain Fragment and Replicate Join. [8]

OR

Q2) a) What is meant by Skew? Explain the different ways of handling Skew. [10]

b) What is the difference between interquery and intraquery parallelism? [6]

Q3) a) If we are to ensure atomicity , all sites in which a transaction T is executed must agree on the final outcome of the execution .T must either commit at all sites or it must abort at all sites. Describe the Protocol used to ensure this property. [8]

b) Explain in detail Replication with respect to Distributed Databases. [10]

OR

Q4) a) Remote backup systems and replication in Distributed Databases are two alternative approaches for providing high availability. Explain the difference between them. [6]

b) How Deadlock handling is done in Distributed Databases? Explain. [12]

Q5) a) How XML data is stored in Relational Databases? Explain. [8]

b) Explain in detail XML schema. [8]

OR

Q6) a) Explain in detail XQuery. [10]

b) Write short note on: XML applications. [6]

SECTION II

Q7) a) In real world data, tuples with missing values for some attributes is a common occurrence. Describe various methods for handling this problem. [10]

b) Explain with suitable example any two operations on multidimensional data. [6]

OR

Q8) a) Explain the following with respect to data preprocessing      [6]

i) Data reduction ii) Data Decretization

b) Explain different conceptual schemas design for data warehouse with suitable example. [10]

Q9) a) Explain classification and prediction with suitable example. [8]

b) Explain outlier analysis. [8]

OR

Q10) a) How are decision trees used for classification? Explain with example. [8]

b) State and explain apriori algorithm. [8]

Q11) a) Define Information retrieval System. How it is different from Database system? [6]

b) Explain the following terms             [12]

i)Web Crawlers ii) Vector space model iii) Synonyms iv) Proximity

OR

Q12) a) How to measure retrieval effectiveness? [6]

b) Explain the following terms             [12]

i) Page Rank ii) Full text retrieval iii) Ontologies iv) Homonyms

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

Go back to Pune University Question Papers page

Advanced Database Management - BE-IT Pune University Question May June 2014

Pune University BE(IT) Question Papers May June 2014 / Previous year BE(Information Technology) question papers of Pune University / BE IT Advanced Databases Question Paper / Pune University Questions with Answers

UNIVERSITY OF PUNE

B. E. (IT) Examination - May 2014

ADVANCED DATABASE MANAGEMENT

(2008 Pattern)

[Time : 3 Hours]                                                                [Max. Marks : 100]

[Total No. of Questions : 12]                                     [Total No. of Printed Pages :3]

Instructions :

(1) Answers to the section should be written in separate books

(2) Neat diagrams must be drawn wherever necessary.

(3) Assume suitable data, if necessary.

(4) Section I :Q1or Q2, Q3 or Q4, Q5 or Q6

(5) Section II: Q7 or Q8, Q9 or Q10, Q11 or Q12

SECTION-I

Q1) a) What is PL/SQL Engine? Draw PL/SQL BLOCK structure. Explain each block. [8]

b) Describe the working of cursor and types of cursors in PL/SQL. [8]

OR

Q2) a) Explain the need of packages and describe the package in detail with its advantages. [8]

b) Compare the Embedded SQL and dynamic SQL. [8]

Q3) a) Write a short not on          [16]

i)Main Memory Database

ii)Real Time Transaction system

OR

Q4) a) What is Transactional Workflow explain in detail with example. [8]

b) Explain the Optimistic concurrency control protocol for Multidatabase System. [8]

Q5) a) Describe XML query algebra operation. Describe FLWOR expression with example. [9]

b) What is Persistent object? Explain the approaches to make the Object Persistent. [9]

OR

Q6) a) What is XML Schema.? Explain with example. [9]

b) Where you would need to use Complex data types? How would you declare structured types using SQL: 1999? [9]

SECTION II

Q7) a) Discuss the features of Star, Snowflake and Fact Constellation schema of Data Warehouse, Compare the above three schemas. [9]

b) Explain Kimball database design methodology for data warehouse. [9]

OR

Q8) a) Present a diagrammatic representation of typical architecture and main components of data warehouse. [9]

b) What is the need of extraction, cleaning and transformation while building data warehouse? Give examples to support your answer. [9]

Q9) a) Explain Aproiri Algorithm with example. [8]

b) What is Data cube? Explain the different operations on data cube. [8]

OR

Q10) a) What is Decision tree? How decision tree is used for classification? [8]

b) What is OLAP benchmark? List the applications and Benefits of OLAP. [8]

Q11) a) Explain what is the need of granting and revoking privileges. [8]

b) Explain different security and integrity threats to the database. [8]

OR

Q12) a) What is authorization and encryption in terms of providing security for database? [8]

b) Explain the statistical database security. [8]

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

Go back to Pune University Question Papers page

Advanced Database Management - Pune University Question Nov Dec 2014

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

UNIVERSITY OF PUNE

[4659]-240

B. E. (Computer Engineering) - 2014

ADVANCED DATABASES

(2008 Pattern)

[Time : 3 Hours]                                                                [Max. Marks : 100]

[Total No. of Questions : 12]                                     [Total No. of Printed Pages :3]

Instructions :

(1) Answers three questions from section I and three questions from section II

SECTION-I

Q1. a) For each of the three partitioning techniques, namely round-robin, hash partitioning, and range partitioning, give an example of a query for which that partitioning technique would provide the fastest response. [6]

b) Write a short note on parallel hash join. [5]

c) What is interquery parallelism? Explain cache coherency problem and protocol available to guarantee cache coherency. [6]

OR

Q2. a) Explain parallel external sort merge. [6]

b) Explain design issues in parallel database systems. [6]

c) What factors could result in skew when a relation is partitioned on one of its attributes by hash partitioning and range partitioning. In each case, what can be done to reduce the skew? [5]

Q3. a) If we are to ensure atomicity, all the sites in which transaction T executed must agree on the final outcome of the execution T must either commit at all sites or it must abort at all sites. Describe the technique or protocol used to ensure this property in detail. [7]

b) Explain how the following differ; Fragmentation transparency, replication transparency, and location transparency. [6]

c) Describe and compare homogeneous and heterogeneous databases with respect to distributed databases. [4]

OR

Q4. a) Explain the following with respect to robustness of distributed databases. [8]

i) Coordinator selection.

ii) Majority based approach.

b) Explain network partition with respect to distributed databases. [5]

c) What are the different approaches to store a relation in the distributed database. Explain them in brief. [4]

Q5. a) Write short notes on: [8]

i) SOAP

ii) Client-Server architecture

b) Explain the structure of XML data with example.  [8]

OR

Q6. a) Explain the following with respect to web architecture. [8]

i) Web server

ii) Common gateway interface

iii) Cookie

iv) Uniform resource locator.

b) Explain XML parsers in detail. [8]

SECTION II

Q7. a) What is data warehouse? What is the difference between data warehouse and operational database system? [9]

b) Explain the following; [8]

i) Data cube

ii) OLAP

OR

Q8. a) Discuss the different data smoothing techniques. [8]

b) Suppose a group of 12 sales price records has been sorted as follows; [4]

5, 10, 11, 13, 15, 35, 50, 55, 72, 92, 204, 215

Partition them into three bins by each of the following methods;

i) Equal-frequency (equidepth) partitioning

ii) Equal-width partitioning

c) Write short note on data mart. [5]

Q9. a) Explain in detail classification and prediction. [8]

b) Explain Apriori algorithm with example. [9]

OR

Q10.a) Consider the following training set. [9]

Write ID3 classification algorithm. Construct a decision tree based on above training set using ID3.

b) What are Bayesian classifiers? [2]

c) Explain K-mean algorithm with example. [6]

Q11. a) What is relevance feedback? Explain in brief. [4]

b) Explain in detail information retrieval and structured data. [6]

c) Explain in detail popularity ranking. [6]

OR

Q12. a) What is the difference between a false positive and a false drop? If it is essential that no relevant information be missed by an information retrieval query, is it acceptable to have either false positives or false drops? Why? [4]

b) Explain in detail web search engines. [6]

c) Explain the following terms with examples w.r.t IR. [6]

i) Homonyms

ii) Synonyms

iii) Proximity

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

Go back to Pune University Question Papers page