BSC-DBMS-IMPQ

BSC Computer Science

DBMS - Imp Questions

1    1. What is DBMS? List out its advantages.
2.       List out the characteristics of DBMS?
3.       Explain about function of DBMS Function.
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 data 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 SQL? Explain about DDL, DML, DCL commands.
20.   What are the basic data types in SQL?
21.   explain about the following

a) Create      b)select     c)truncate           d)alter          e) group by         f) having              g) order by

2    22.    Explain about various types of operators in SQL?

2    23.   Explain about aggregate functions in SQL.

2    24.   Explain about relation set operators?

2    25.   discuss about nested queries and correlated queries.

2    26.   explain about SQL joins?

2    27.   explain briefly about triggers with example.

2    28.   what is a cursor explain with example.

2    29.   what is an exception in PL/SQL? explain.

3    30.   what is a package? explain different types of packages in PL/SQL.