Important questions of DBMS for III B.Com(CA)

Unit-1

1. Define a)Data  b)Data Base  c)Information d)DBMS
2. What are the Objectives of DBMS.
3. Explain the classification of DBMS.
4. Explain the history of DBMS.
5. Explain in detail about the three tier schema architecture of DBMS.

Unit-2

1. Discuss the main characteristics of the database approach and specify how it differs from traditional file system.
2. What are the drawbacks of File-Based System
3. Explain briefly about different types of Data Models.
4. Briefly explain Components of DBMS.
5. What are the responsibilities of DBA b) What are the different types of database end users? Discuss the main activities of each.
6. Write a note on Vendors and its products in DBMS.

Unit-3

1. Discuss in detail about the concepts of E-R model with suitable examples.
2. Explain the difference among Entity, Entity Type & Entity Set.
3. What is Attribute? Explain attribute classification.
4. What is Relationship? Explain Degree of Relationship.
5. Write a note on Generalization and Specialization with example.
6. Write different CODD's Rules in DBMS.
7. Explain about Set operators in Relational algebra. b) Explain about Mapping of Binary 1:1 relationship types and Binary M:N relationship type

Unit-4

1. Mention various DML operations with examples.
2. Describe the concept of Referential Integrity.
3. List and explain the common data types available in SQL.
4. What is a group function? List and explain how to use group functions in SQL with appropriate examples.
5. Explain Set Operations.

Unit-5

1. Explain the structure of PL/SQL.
2. Explain briefly about Control Structures in PL/SQL.
3. Write a note on Iterative Controls.
4. Define Cursor. Explain Active Set.
5. Explain different types of Triggers in PL/SQL.
6. Difference between Function and Package in PL/SQL.