Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 2nd Sem (Second Semester) Regulation-R19 2021 July-August 862AC Database Management Systems Previous Question Paper
R19
Code No: 862AC
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
2021 MCA II Semester Examinations, July/August - 2021
DATABASE MANAGEMENT SYSTEMS
Time: 3 Hours
Max.Marks:75
Answer any five questions
All questions carry equal marks
- - -
1.a) Explain the Database system structure.
b) Discuss conceptual database design for large enterprises.
[7+8]
2.a)
Explain the role of file manager and buffer manager in DBMS.
b)
Describe the components of query processor and query evaluation engine with
necessary diagram.
[7+8]
3.a)
What is a view? Discuss its role in Database security.
b)
Explain in detail the Division operation in Relational Algebra.
[7+8]
4.a)
What is relational database. Illustrate Tuple relational calculus.
b)
Explain domain relational calculus.
[7+8]
5.a)
Compare Nested query and correlated query. Discuss suitable examples.
b)
What is a Trigger? How do they enforce Integrity constraints?
[7+8]
6.a)
Describe Multi-valued dependencies with examples.
b)
Explain the various problems caused by Redundancy.
[7+8]
7.a)
Explain the concept of log based recovery.
b)
Explain advanced recovery systems.
[7+8]
8.a)
What is an index? Differentiate between Sparse and dense indices.
b)
Make a comparison of Sorted file organization.
[7+8]
---oo0oo---
This post was last modified on 17 March 2023