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.
Each question carries 20 marks.

QQ1. a) What is a functional dependency? How can we preserve the dependencies in a relation during decomposition? (10) b) What do you mean by Multi-valued dependencies? Discuss with a suitable example? (10) [20 marks]
QQ2. a) What are views and what is their significance? How views are managed in SQL, explain using an example? (10) b) Explain hash join and complex join with a suitable example? (10) [20 marks]
QQ3. a) What is Merge Join? Discuss its implementation with a suitable example? (10) b) Explain query optimization? How it is implemented? (10) [20 marks]
QQ4. a) How does Boyce-Codd Normal form differ from 3NF? Why is it considered stronger than 3NF, explain using a suitable example? (10) b) How can we implement security in a database using SQL? (10) [20 marks]

QQ5. What is meant by a schedule in the context of concurrent transactions in Database? Also explain serial and serializable schedules with the help of a suitable example. (20) [20 marks]
QQ6. a) What are multimedia Databases? Explain the features and challenges of multimedia databases? (10) b) How does Distributed DBMS differ from Centralized DBMS? Explain the reference architecture of Distributed DBMS? (10) [20 marks]
QQ7. Define locking in concurrency control? Discuss the various types of locking techniques? (20) [20 marks]
QQ8. a) How is data fragmentation and data replication achieved in distributed databases? (10) b) What is an Object Relational database? What are its characteristics? (10) [20 marks]