BSC-DBMS IMP QUESTIONS

 

BSC Computer Science

DBMS - Imp Questions

BSC(MPCS,MECS)

1.      What is DBMS? List out its advantages.
2.       Write about data, database and DBMS?
3.       Explain about functions of DBMS .
4.       What are the drawbacks of file processing system over DBMS. Explain.
5.       Classification of DBMS?
6.       What is a data model? Explain about different data models in DBMS.
7.       What are the components of DBMS? Explain.
8.       Explain about DBMS Architecture.
9.       What are the basic building blocks of ER model? Explain.
10.   Explain about Relational model.
11.   What is ER Model? Explain with Suitable example.

12.   Briefly discuss about EF Codd rules in DBMS.
13.   Explain about EER Model.
14.   What is a relation? explain about relation algebra.
15.   Explain about tuple and domain relation calculus.
16.   Explain about specialization, generalization, aggregation (inheritance)
17.   What is a key? Describe different types of keys in relational model.
18.   What are the difference between DBMS vs RDBMS? Explain.

19. What is an Entity? Explain about Different types with examples.

20. Write about relationship degree?

21. What are the different types of relationships? Explain.

22.   What is SQL? Explain about DDL, DML, DCL commands.
23.   What are the basic data types in SQL?
24.   Explain about the following Commands

      a) Create      b)select     c)truncate           

25. Briefly explain about

      d) alter          e) group by           g) order by

26.    Explain about various types of operators in SQL?

27.   Explain about aggregate functions in SQL.

28.   Explain about relation set operators?

29.   Discuss about nested queries and correlated queries.

30.   Explain about SQL joins?

31. What is a constraint? Explain different types of constraints.

32. What is a view? How to create views on sql.

33.  how to create table on sql? Explain with example.

34. What is PL/SQL? Explain basic structure of PL/SQL.

35. Write about different types of operators on PL/SQL.

36. Write about control structures on PL/SQL.

37.   Explain briefly about triggers with example.

38.   What is a cursor explain with example.

39.   How to handle exceptions in PL/SQL? Explain.

40.   What is a package? Explain different types of packages in PL/SQL.