
	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 >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

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. Q4) a) b) c) Q5) a) b) Explain Data Fragmentation in distributed databases. [6] Explain the following with respect to robustness of distributed databases. i) Read one, write all available protocol. [10] ii) Co-ordinator selection. iii) Majority-based approach. What is Persistent messages? [2] Explain the following with respect to web architecture [8] i) Web server. ii) Common gateway interface. iii) Cookie. iv) Uniform Resource Locator. Explain the components of an XML document with suitable example.[8] OR Q6) a) b) c) Explain the following terms and describe what they are used for i) XPath. ii) SOAP. Write short notes on i) Client - Server architecture. ii) Advantages of N-tier architecture. What is XSL? [6] [8] [2] SECTION - II Q7) a) b) What is a Data warehouse? Explain the key features of Data warehouse.[6] Write short notes on : [12] i) Handling missing values in Data cleaning. ii) Three-Tier data warehouse architecture. iii) Data cubes. OR Q8) a) b) Explain the following OLAP operations on multidimensional data [6] i) Roll-up. ii) Slice and dice. Write short notes on [12] i) Data Transformation. ii) Data Reduction. iii) Fact constellation. [3664] - 339 -2- Q9) a) b) Explain the following with suitable example [8] i) Data characterization. ii) Data discrimination. State and explain the algorithm to generate a decision tree from training tuples. [8] OR Q10)a) b) c) Explain in detail classification and prediction. What is outlier analysis? Write the k-means algorithm for partitioning. [8] [4] [4] Q11)a) b) c) d) What is relevance feedback? Explain in brief. Explain in detail Web Search Engines. What is the difference between a false positive and a false drop? Explain the following terms i) Homonyms. ii) Ontologies. [4] [6] [2] [4] OR Q12)a) b) c) d) What is meant by search engine spanning? Explain in brief. Explain in detail Information retrieval and structured data. What is the difference between precision and recall? Explain the following terms : i) Synonyms. ii) Inverted index. [3664] - 339 -3- [4] [6] [2] [4]

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: