BCOM DBMS - IMP Question

 

BCOM Computer Science

DBMS - Imp Questions

BCOM

 

Module I

1.      What are the advantages of DBMS? Explain.

2.    What is data, database and DBMS? Explain.
3.       List out the characteristics of DBMS?
4.       Explain about functions of DBMS .
5.       What are the drawbacks of file processing system over DBMS. Explain.
6.       Classification of DBMS?

7.    Evolution of DBMS? / History of DBMS.
8.      Explain about different data models in DBMS.
9.       What are the components of DBMS? Explain.
10.       Explain about DBMS Architecture.

11.    Write about 3 Schemas Architecture?

 

Module II
12.       What are the basic building blocks of data model? Explain.
13.   Explain about Relational model.
14.   What is ER Model? Explain with Suitable example.

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

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

23. Write about relationship degree?

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

 

Module III
25.   Write about SQL Commands? or Explain about DDL, DML, DCL commands.
26.   What are the data types in SQL? Explain.
27.   Explain about the following Commands

      a) Create      b) select     c)truncate           

28. Briefly explain about

 d) alter          e) group by           g) order by

29.    Explain about various types of operators in SQL?

30.   Explain about aggregate functions in SQL.

31.   Explain about relation set operators?

32.   Discuss about nested queries and correlated queries.

33.   Explain about SQL joins?

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

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

 

Module IV

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

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

38. Write about control structures on PL/SQL.

39.   Explain briefly about triggers with example.

40.   What is a cursor explain with example.

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

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