DBMS_Imp_Questions

DB

DBMS Important Questions

Important unit-wise questions for Database Management System

📚 DBMS Question Bank

I Unit – I

1. Explain Advantages and Disadvantages of DBMS?
2. Explain Functions of DBMS?
3. Explain Three-level ANSI-SPARC Architecture.
4. Describe Various Data Models?
5. Explain File Based System and Disadvantages?

II Unit – II

1. What is ER Modeling? Explain Entities & Types, Relationship & Types, Attributes & Types?
2. Explain Strong and Weak Entities?
3. Define Normalization? Explain Various Normal Forms?
4. Describe Specialization and Generalization, Aggregation?
5. Draw ER Model for:

   📐 ER Model Questions

   a) Library Management System

   b) Hospital Management System

   c) Other suitable systems

III Unit – III

1. Explain DDL and DML Commands?
2. Explain:

   a) ORDER BY

   b) GROUP BY

   c) Aggregate Functions
3. Describe Views with Example?
4. Define Joins and Types of Joins?
5. Explain Trigger with Example?
6. Explain Control Statements in PL/SQL?
7. Explain Functions and Procedures?
8. Explain Cursor with Example?

IV Unit – IV

1. Explain about Deadlock in detail?
2. Describe Timestamp Based Protocol for Concurrency Control?
3. Explain Lock and Types of Locks?
4. Explain Two-Phase Locking Protocol?
5. Explain Optimistic Techniques?
6. Explain:

   a) Properties of a Transaction

   b) Recovery Techniques

   c) Computer Based Controls

   d) Database Backup and Recovery

   e) concurrency controle ,Serializability,Recoverablity

🎓 DegreeCSA

Computer Science Learning Platform

Visit: degreecsa.blogspot.com