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.
- University: Government College of Engineering and Technology, Jammu
- Subject: RDBMS
- Course: Database Application and Design
- Branch: Information Technology Engg.
- Year: 2018
- Paper: end-term
- Duration: 180 minutes
- Total marks: 100
Instructions
- Attempt five questions in all, selecting at least Two questions from each section.
- All questions carry equal marks.
Questions
Section-A
- Q1. (A) What are integrity constraints in SQL? (12) (B) Explain the Security in SQL. (8) [20 marks]
- Q2. Explain various strategies that are used for query optimization. (20) [20 marks]
- Q3. (A) What is multi-valued dependency? Discuss with example normalization with multi-valued dependency. (10) (B) Explain Hash join and complex join. (10) [20 marks]
- Q4. (A) Define query processing and query optimization. Why is query optimization required. (10) (B) How do we decompose the relational schema. (10) [20 marks]
Section-B
- 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) What are ACID properties? Explain the same with suitable examples. (12) (B) What is Optimistic Concurrency Control in Database Management Systems? Explain in detail about Optimistic Concurrency Control. (8) [20 marks]
- Q7. (A) How is data fragmentation and data replication achieved in distributed databases? (10) (B) Explain advantages of distributed databases. (10) [20 marks]
- Q8. Explain the following: a. Spatial databases (10) b. Multimedia database (10) [20 marks]
Related pages
Other years
- RDBMS 2018 question paper — end-term
- RDBMS 2018 question paper — end-term
- RDBMS 2018 question paper — end-term