
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

2003 Course Advanced Databases (Elective I)

3 pages, 51 questions, 0 questions with responses, 0 total responses,

	pune_eng	+Fave Message
	Profile Timeline Uploads Q & A

Home > pune_eng >

Formatting page ...

Total No. of Questions : 12] [Total No. of Pages : 3 [3664] - 339 P 1220 B.E. (Computer Engineering) ADVANCED DATABASES (2003 Course) (410445) (Elective - I) Time : 3 Hours] [Max. Marks : 100 Instructions to the candidates: 1) Answers to the two sections should be written in separate books. 2) Neat diagrams must be drawn wherever necessary. 3) Figures to the right indicate full marks. 4) Assume suitable data, if necessary. SECTION - I Q1) a) b) c) Some parallel database systems store an extra copy of each data item on disks attached to a different processor [4] i) Explain the reason for above strategy. ii) What is the advantage if you partition the copies of data items of a processor across multiple processors. Explain the following with suitable example [6] i) Pipelined parallelism. ii) Independent parallelism. What is meant by horizontal partitioning? Explain any two partitioning techniques. [6] OR Q2) a) b) c) Q3) a) b) c) In a range selection on a range - partitioned attribute, it is possible that only one disk may need to be accessed. Describe the benefits and drawbacks of this property. [4] What is interquery parallelism? Explain cache coherency problem and protocol available to guarantee cache coherency. [6] Explain parallel External sort-Merge. [6] Explain Data Replication in distributed databases. [6] Explain the different system failure modes in distributed transaction model. How the two-phase commit protocol handles these failures. [10] What is multimaster replication? [2] OR P.T.O.

Formatting page ...

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

pune_eng chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: