My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Download Model question papers & previous years question papers
|
Posted Date: 10 Jun 2009 Posted By: Magic Member Level: Gold
|
2009 Shivaji University Computer Science B.E. (Computer Sci. & Engg.)(Semester-VIII)Examination, 2009 ADVANCED DATABASE SYSTEM Question paper
B.E. (Computer Sci. & Engg.)(Semester-VIII)Examination, 2009
ADVANCED DATABASE SYSTEM
Day and Date: Wednesday, 18-05-2009
Time: 10.00a.m. To 1.00 p.m. Total Marks: 100
Instructions: 1) Q.4 &Q.8 are compulsory.
2) Answer any two questions from remaining in each section.
3) Figures to the right indicate full marks.
SECTION-I
1. a) Illustrate with example. Nested relational model.
b) Explain SQL functions and procedures.
2. a) Discuss in detail centralized and client-server systems.
b) What is distributed deadlock? How to handle it?
3. a) Explain Attribute value and partition skew. How to handle the skew?
b) What is homogenous and heterogeneous database? How to store data in distributed DBMS using replication?
4. Write short notes on: (any three)
a) Complex types.
b) Intraquery Parallelism.
c) Three phase commit
d)Parallel database architecture.
SECTION-II
5. a) Discuss the need for standardization. Explain DB connectivity standards and XML-based standards.
b) What is support and confidence? Explain an algorithm for finding association rule.
6. a) Explain with example extended aggregation and ranking.
b) Draw typical data warehouse architecture. Explain each block in brief.
7. a) With the help of diagram discuss detail structure of TP monitor..
b) What is the purpose of compensating transaction? Present two examples of their use.
8. Write short notes on: (any three)
a) Clustering.
b) MOLAP.
c) Main memory database
d) E-commerce.
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.
|
Advertise Here
|