RDBMS 2018 Question Paper — Government College of Engineering and Tec…

The 2018 RDBMS previous year question paper (Government College of Engineering and Technology, Jammu), with every question and its marks.

Instructions

Attempt five questions in all, selecting at least two questions from each section.
All Questions carry equal marks.

Q1. (A) Give a typical example for the 4th Normal Form and explain the importance of fourth normal form. (12) (B) Explain Join dependencies and the fifth normal form. (8) [20 marks]
Q2. (A) Explain the role of keys in Database Management System. Differentiate between super key, primary key, candidate key and foreign key. (12) (B) How is Embedded SQL different from Dynamic SQL. (8) [20 marks]
Q3. How is SQL embedded in programming? How is it different from dynamic SQL? Explain with examples. (20) [20 marks]
Q4. (A) Explain Nested Loop Join and Merge Join with suitable examples. (12) (B) What are different strategies for query optimization? (8) [20 marks]

Q5. (A) Why is concurrency control needed in Database Management Systems? Explain the techniques used for concurrency control in detail. (12) (B) Write a note on Object Relational Database. (8) [20 marks]
Q6. (A) Explain simple transactional model. Explain the read and write only model. (10) (B) Explain Deductive Databases and Mobile databases. (10) [20 marks]
Q7. (A) Explain time stamp. Explain how it can be used to ensure durability of a transaction. (10) (B) Explain the client server 3 tier architecture. (10) [20 marks]
Q8. (A) How is data fragmentation and data replication achieved in distributed databases. (10) (B) Explain advantages of distributed databases. (10) [20 marks]