M.Tech-M.Tech Computer Science 4th Sem ADVANCED DATABASE MANAGEMENT SYSTEMS(Acharya Nagarjuna University (ANU), Guntur, Andhra Pradesh-2012)

M.Tech. DEGREE EXAMINATION, MAY 2012.
(Examination at the end of Final Year)
Computer Science
Paper I — ADVANCED DATABASE MANAGEMENT SYSTEMS
Time : Three hours Maximum : 75 marks
Answer Question No. 1 compulsorily. (15 × 1 = 15)
Answer ONE question from each Unit. (4 × 15 = 60)
1. Write a brief note on :
(a) Define tuple.
(b) Define DBMS.
(c) Define data Independece.
(d) What is E-R Model?
(e) Define Record with example.
(f) Define distributed DBMS.
(g) What is OLAP?
(h) What is Trigger?
(i) What is Query Optimization?
(j) What is paging?
(k) What is fragmentation?
(l) Define Aggregation.
(m) Write about XML.
(n) What is dead lock?
(o) What is query processing?
UNIT I
2. (a) Explain the concepts for object oriented database. (6)
(b) Explain database languages, database users and administrations. (9)
Or
3. Explain about physical database design in relational database. (15)
UNIT II
4. Explain the architecture of the distributed DBMS. (15)
Or
5. What is E-R diagrams? What are the uses of it? Explain in detail. (15)
UNIT III
6. How expressions are executed in query processing? Explain in detail. (15)
Or
7. What is data localization? Explain in detail about optimization of distributed queries.
UNIT IV
8. (a) What is two-phase locking protocol? (5)
(b) What are the application explain with example? (10)
Or
9. Explain distributed concurrency control and briefly discuss in reliability.