Download OU (Osmania University) B.Sc Computer Science 4th Sem Data Base Management System Important Question Bank For 2021 Exam
Subject Title: Data Base Management System
Prepared by: K Madhavi
Year: II
Semester:
IV
Updated on: 23-03-
Unit - I:
1.
What is Traditional file based system and Database approach?
2.
What are the advantages and disadvantages of DBMS?
3.
Explain Three-level ANSI-SPARC Architecture.
4.
What are the functions of DBMS?
5.
Explain the components of DBMS.
6.
Explain in detail about Relational Algebra(Unary, set,join operators)
7.
Explain Different Data Models?
8.
List some aggregate functions in SQL
9.
Users of DBMS.
10. Integrity constraints.
Unit - II:
11. Explain in detail about SQL Data types?
12. How to create, Alter a table explain with example
13. What is a View? Explain Different types of views?
14. How to give Privileges to users? Explain.
15. Explain Control Structure in PL/SQL?
16. Explain Cursors in PL/SQL?
17. Explain Packages in PL/SQL?
18. Explain Procedures in PL/SQL?
19. Explain Functions in PL/SQL?
20. Explain Triggers in PL/SQL?
21. What are sub queries and nested queries?
22. Transactions in SQL(TCL)
Page 1 of 2
Unit - III:
23. Explain in detail about different types of entities and attributes.
24. What are the problems with ER model?
25. What are the basic constructs of ER model?
26. What is an EER model?
27. Explain functional dependency.
28. Explain about different Normal Forms.
29. Why do we need normalization?
Unit - IV:
30. What are the different Concurrent problems? Explain with example.
31. What is a lock? Types of locks in DBMS
32. How data recovery works?
33. What are computer based controls?
34. Write about RAID tools.
Page 2 of 2
This post was last modified on 23 January 2021