UPTU Previous Year Exam Papers
Advanced Concept in Database System
Note : (1) Attempt all the questions, choices are within each question. (2) All questions carry equal marks.
1. Attempt any two of the following :
a. (i) How does the concept of an object oriented model differ from the concept of an entity in the E-R Model? Explain in detail, (ii) What do you mean by fragmentation? What do you understand by Horizontal, vertical and mixed fragmentations?
b. Explain logic based data model in detail.
c. Discuss the advantages and disadvantages of distributed database.
2. Attempt any two :
a. Discuss parallel and pipeline join with the help of example.
b. Discuss the spatial and multimedia database in detail.
c. Consider the relations rA (A, B, C), r2 (C, D, E) and r3 (E, F) with primary key A, C, E respectively. Assume that rA has 1000 tuples, r2 has 1500 tuples and r3 has 750 tuples. Estimate the size of rl X , r2x,r3 and give an efficient strategies for computing the join operation. .
3. Attempt any two :
|a.||Discuss the role of DBA in distributed database system.|
|b.||Discuss commit protocols. Also, explain three phase|
|commit protocol in detail.|
|c.||What do you mean by Query processing? Discuss|
|the various transformation rules of query processing.|
|4. Attempt any two :|
|a.||Why is query expressed in relational algebra preferred|
|over query expressed in SQL. Explain this by taking|
|a suitable example.|
|b.||Write a short note on estimation of query processing|
|c.||Discuss the system catalogue in RDBMS.|
5. Write short notes on any two of the following :
a. Expert and web database
b. Temporal and deductive database
c. Object identity and containment
d. Distributed deadlock and recovery.