FirstRanker.com
Firstranker's choice
Code No: 823AC
--- Content provided by FirstRanker.com ---
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA III Semester Examinations, January - 2018
DATABASE MANAGEMENT SYSTEMS
Time: 3hrs Max.Marks:75
Note: This question paper contains two parts A and B.
--- Content provided by FirstRanker.com ---
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part Bconsists of 5 Units. Answer any one full question from each unit. Each question carries
10 marks and may have a, b, c as sub questions.
PART - A
5 x 5 Marks =25
--- Content provided by FirstRanker.com ---
- a) What is the purpose of database system? [5]
- b) Differentiate between tuple and domain relational calculus. [5]
- c) Define functional dependency. Quote two examples. [5]
- d) What is check pointing? [5]
- e) Compare heap file organization with hash file organization. [5]
--- Content provided by FirstRanker.com ---
PART-B
5 x 10 Marks =50
- List the four categories of database users and explain their interfaces to database management system and their functionality. [10]
OR--- Content provided by FirstRanker.com ---
With suitable examples discuss the following integrity constraints on DBMS:
a) Candidate key b) domain constraint c) primary key d) foreign key [10] - Describe the six primitive operators of relational algebra with examples. [10]
OR
Consider the following database schema to write queries in SQL--- Content provided by FirstRanker.com ---
Sailor (sid, sname, age, rating)
Boats (bid, bname, bcolor)
Reserves (sid, bid, day)
a) Find the names of the sailors who have reserved at least two boats.
b) Find the colors of the boats reserved by sailor ‘Raj’.--- Content provided by FirstRanker.com ---
c) Find the sailor who have reserved all red boats. [10] - What is redundancy? Explain the problems caused by redundancy in database design.[10]
OR
a) Why is BCNF stricter than 3NF?
b) Discuss inclusion dependencies. [5+5] - Explain how two phase locking protocol ensures conflict serializability. [10]
OR
a) What are the merits of validation based protocol over time stamp based protocol?
b) How to deal with deadlocks in databases? [5+5] - Describe the following terms with respect to disk organization: track, sector, cylinder,
--- Content provided by FirstRanker.com ---
access time, rotational delay. [10]
OR
What is multi level indexing? What is its purpose in DBMS? Is B+ tree a multi level indexing? Justify your answer. [10]
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
This download link is referred from the post: JNTUH MCA 3rd Sem Last 10 Years 2023-2013 Question Papers R20-R09 || Jawaharlal nehru technological university