Download JNTUH MCA 3rd Sem R17 2021 February 843AA Database Management Systems Question Paper

FirstRanker.com

Code No: 843AA

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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

FirstRanker.com

R17

MCA III Semester Examinations, February - 2021

DATABASE MANAGEMENT SYSTEMS

Time: 2 hours Max.Marks:75

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

Answer any five questions

All questions carry equal marks

1. a) Discuss the Entity-Relationship Model. Explain with suitable examples.
   b) Compare and contrast the DDL and DML. [8+7]
2. a) Explain the following:
   

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

   a) Null values
   b) Outer joins
   c) Triggers [5+5+5]
3. a) How do you develop Security and authorization with SQL? Explain.
   b) Write a short note on logical connectivity. [7+8]

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

4. Describe the set operations of relational algebra, including union (U), set difference (-) and cross-product (X). For each, what can you say about the cardinality of their input and output tables? [15]
5. Briefly explain the properties of decompositions in detail. [15]
6. a) Define transaction. Explain the state diagram of a transaction in detail.
   b) What is serializability? Explain. [7+8]
7. Discuss two-phase lock based protocol and time-stamped protocol and compare them with suitable examples. [15]

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

8. a) How does a B+ tree index handle the search, insert and delete?
   b) Explain the primary indexing and secondary indexing. [7+8]

---00000---

FirstRanker.com

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