Previous Year Very Short Questions of RDBMS (MCA 2nd)

Relational database management system

Previous year question paper with solutions for Relational database management system

Our website provides solved previous year question paper for Relational database management system . Doing preparation from the previous year question paper helps you to get good marks in exams. From our RDBMS question paper bank, students can download solved previous year question paper. The solutions to these previous year question paper are very easy to understand.

These Questions are downloaded from www.brpaper.com You can also download previous years question papers of 10th and 12th (PSEB & CBSE), B-Tech, Diploma, BBA, BCA, MBA, MCA, M-Tech, PGDCA, B-Com, BSc-IT, MSC-IT.

Print this page
  1. What is Data Independence? List its types.
  2. With example explain referential integrity constraint with an delete cascade.
  3. What is client server architecture? Give suitable example, compare network and hierarchical model.
  4. Draw an ER diagram for Institute management system.
  5. List and explain the steps for query processing.
  6. Normalize the following database up to 3NF STUDENT (stud-no, stud-name, studadd, course-no, course-title, teacher-name, marks-obtained
  7. Define the five basic operators of relational algebra with an example each.
  8. Differentiate between Data Base Instance and Data Base Schema. Explain Three-Schema Data Base architecture in detail.
  9. The NCL has many teams,
  10. Each team has a name, a city, a coach, a captain, and a set of players,
  11. Each player belongs to only one team,
  12. Each player has a name, a skill level, and a set of injury records,
  13. A team captain is also a player,
  14. A game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 16th, 2016) and a score.
  15. What is Functional Dependency? Explain in detail the first three Normal Forms and the Boyce Codd Normal form (Along with anomalies and examples).