Download VTU B-Tech/B.E 2019 June-July 1st And 2nd Semester 2015 June-July 14CIV18 Environmental Studies Question Paper

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

R18 B.Tech II Year II Semester Examinations, November/December - 2020

DATABASE MANAGEMENT SYSTEMS

(Common to CSE, IT)

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

Time: 3 Hours Max. Marks: 75

Note: This question paper contains two parts A and B.

Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks.

PART - A (25 Marks)

1. Answer all questions

   1. Define Data, Database and DBMS. (2M)

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

   2. What are the advantages of using DBMS? (3M)
   3. What is a candidate key? Explain. (2M)
   4. Describe the purpose of foreign key. (3M)
   5. What is normalization? (2M)
   6. Explain about 1NF. (3M)

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

   7. What is transaction? (2M)
   8. Explain the ACID properties of transactions. (3M)
   9. What is serializability? (2M)
   10. List different lock modes. (3M)

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

PART - B (50 Marks)

(Answer all five units, choosing one question from each unit)

UNIT - I

1. Explain the structure of DBMS with neat diagram. (10M)

   OR

   Explain different types of data models with examples. (10M)

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

UNIT - II

1. Explain about different types of constraints in SQL with examples. (10M)

   OR

   Consider the following relations:

   Sailors (sid: integer, sname: string, rating: real, age: integer)

   Boats (bid: integer, bname: string, color: string)

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

   Reserves (sid: integer, bid: integer, day: date)

   Write the following queries in SQL:

   1. Find the names of sailors who have reserved boat 103. (3M)
   2. Find the sids of sailors who have reserved a red boat. (3M)
   3. Find the names of sailors who have reserved at least one boat. (4M)

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

UNIT - III

1. What is functional dependency? Explain different types of functional dependencies with examples. (10M)

   OR

   Consider the relation R = {A, B, C, D, E, H} and the set of functional dependencies:

   A ? B

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

   AC ? D

   E ? C

   AD ? E

   H ? AG

   i. Is ADH a superkey? (5M)

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

   ii. Is EH a superkey? (5M)

UNIT - IV

1. Explain different types of concurrency control techniques. (10M)

   OR

   Explain the concept of deadlock. How is it detected and resolved? (10M)

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

UNIT - V

1. Discuss different types of failures. Explain different recovery techniques. (10M)

   OR

   Explain the concept of deferred database modification. Explain the deferred database modification recovery algorithm. (10M)

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

---oo0oo---

Get more study materials from FirstRanker.com