Trending ▼   ResFinder  

2003 Course Advanced Database Management

4 pages, 36 questions, 0 questions with responses, 0 total responses,    0    0
pune_eng
   		+Fave Message
ProfileTimelineUploadsQ & A
 Home > pune_eng >

Formatting page ...

Total No. of Questions : 12] P1328 [Total No. of Pages : 4 [3664]-350 B.E. (IT) ADVANCED DATABASE MANAGEMENT (2003 Course) (414442) Time : 3 Hours] [Max. Marks : 100 Instructions to the candidates : 1) Answers to the two sections should be written in seperate books. 2) Neat diagrams must be drawn wherever necessary. 3) Assume suitable data, if necessary. 4) Section I : Q1 or Q2, Q3 or Q4, Q5 or Q6. 5) Section II : Q7 or Q8, Q9 or Q10, Q11 or Q12. SECTION - I Q1) a) Explain Transaction Server Process Structure. [6] b) What factors result in skew when a relation is partitioned on one of its attributes by Hash Partitioning and Rang Partitioning? In each case, what can be done to reduce the skew? [5] c) Write a short note on Parallel Hash Join. [5] OR Q2) a) b) Describe different approaches to handle cache coherency problem in Parallel Databases. [8] Evaluate how well partitioning techniques support the following types of data access. i) Scanning the entire relation. ii) Locating tuple associatively. iii) Locating all tuples such that the value of given attribute lies within a specified range. [8] Q3) a) Define Distributed Databases. Explain types of Distributed Database Management System Architectures. [6] b) State different types of failures in distributed systems and explain failure handling in distributed database using 2Phase Commit protocol. [6] Describe how LDAP can be used to provide multiple hierarchical views of data, without replicating the base level data. [6] c) P.T.O.

Formatting page ...

Formatting page ...

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 


Tags : Pune, Engineering, University of Pune, Engineering question papers, Pune University, previous year question papers, question papers, india, model question paper, pune university paper pattern, pune university syllabus, old question papers  

© 2010 - 2024 ResPaper. Terms of ServiceContact Us Advertise with us

 

pune_eng chat