Download JNTUH MCA 3rd Sem R15 2018 January 823AC Database Management Systems Question Paper

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
5 x 5 Marks =25

--- Content provided by FirstRanker.com ---

1. a) What is the purpose of database system? [5]
   
2. b) Differentiate between tuple and domain relational calculus. [5]
3. c) Define functional dependency. Quote two examples. [5]
4. d) What is check pointing? [5]

--- Content provided by FirstRanker.com ---

5. e) Compare heap file organization with hash file organization. [5]

PART-B
5 x 10 Marks =50

1. 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]
2. 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]
3. 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]

--- Content provided by FirstRanker.com ---

4. 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]
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]