Previous Year Very Short Questions of RDBMS (BSC-IT 5th)

Rbdms-2

Previous year question paper with solutions for Rbdms-2

Our website provides solved previous year question paper for Rbdms-2 . 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. Differentiate between a procedure and a function.
  2. Define Entity and Attribute.
  3. What is an Exception?
  4. What do you mean by integrity of data? List any two integrity constraints.
  5. Differentiate between row and statement triggers.
  6. List any four Oracle built in functions.
  7. Explain %rowtype attribute in PL/SQL.
  8. Write a PL/SQL block to find sum of first 100 numbers.
  9. What is a Database View and what are its advantages?
  10. How can you enable and disable a database trigger.
  11. What do you understand by Relational Database Management System?
  12. What are the advantages of encrypting data stored in the database?
  13. What is a foreign key?
  14. For what purpose do we use locks in SQL?
  15. State Integrity.
  16. Define Triggers.
  17. Name the different keys that are used in RDBMS.
  18. Name at least four pre defined exceptions.
  19. When is an Explicit cursor used?
  20. Define DML (Data Manipulation Language).
  21. What is Primary Key and Candidate Key?
  22. What is the UNIQUE Constraint? Give example.
  23. How to Destroy a Table in SQL? Give example.
  24. How we can sort data by using ORDER BY clause?
  25. What is the advantage of CHECK constraint?
  26. Give SQL Statement to alter a Table structure in SQL.
  27. Differentiate between Database and Database Management System.
  28. What is the use of Group By Clause give appropriate example to highlight the use?
  29. What is the use of UNION and INTERSECT operator?
  30. What is Sub-Query? Explain with example.