Data Base Management System(VVI Question) for BCA Semester V University Exam

 Data Base Management System
VVI Question 

1. Define DBMS (data base management system). Explain advantage and disadvantage of DBMS.  what  are the data base system application?

2. what is data model? Explain the different types of data model.

3. what is specialization and generalozation?

4. what is entity set? Explain the weak and strong entity set.

5. what is 1NF , BCNF & 3NF in DBMS?

6. what is key? Explain different types of key in DBMS.

7. what are the relational and structral constraints?

8. write the short notes :-

   a) functional dependency

   b) primary key, not null key & unique key

   c) Hashing 

   d) Data dependency

   e) ER and EER diagram

   f) B- tree & B++ tree

9. what is DBMS architecture? discuss the tree level architecture of DBMS.

10. what is normalization? why do we need normalize the data base?

11. what is three schema architecture? what is the objective of three schema architecture?

12. what is structural query language?

13. what is SQL Queries? what is different categories in SQL queries?

14. what is locking technique and associated in DBMS ? Explain binary, shared & exclusive locks.

15. Explain superclass, inheritance and subclass with example.