Subject question bank

Database Management System Questions for Exams

Prepare for semester exams using important questions, numericals, viva questions and unit-wise questions.

U1 Introduction to DBMS U2 Relational data Model and Language & SQL U3 Database Design & Normalization U4 Transaction Processing Concept U5 Concurrency Control Techniques
U

Unit-wise questions

Unit 1

Introduction to DBMS

Open unit →
  1. Database management System and its Capabilities
  2. Advantages and Disadvantages of DBMS
  3. Major Components of DBMS
  4. File System in DBMS with Explanation
  5. Difference Between Database System and File System
  6. What Problem caused by data redundancies? Can data redundancies be completely eliminated when the database approach is used?
  7. What is Instance and schema in DBMS?
  8. How a category differ from regular shared subclass in DBMS?
Unit 2

Relational data Model and Language & SQL

Open unit →
  1. What do you mean by relational model? Explain with example.
  2. What is relational algebra ? Discuss its basic operations.
  3. Write the operations in Relational Algebra.
  4. What is relational algebra?
  5. Describe the tuple and domain relational calculus with suitable example.
  6. What do you mean by referential integrity ? Explain the concept of Foreign key with a suitable example.
  7. What is Cursor? Write the difference between implicit cursor and explicit cursor.
  8. Define the following terms: 1. Super key 2. Candidate key 3. Primary key
Unit 3

Database Design & Normalization

Open unit →
  1. Write a short note on decomposition.
  2. Write a note on Normalization.
  3. What do you mean by lossless join? Explain.
  4. What do you mean by dependency preservation?
  5. Define Functional Dependency ? What do you mean by Lossless Decomposition? Explain with a suitable example how functional dependencies can be used to show that decomposition are lossless.
  6. What is functional dependency? Explain its role in database design. Describe the inference rules for functional dependencies.
  7. Write the process of normalization.
  8. Define Normal forms. List the definitions of First, Second and Third normal forms.
Unit 4

Transaction Processing Concept

Open unit →
  1. Transactions in DBMS, Its states and ACID Properties
  2. What is Serializability?
  3. Explain the view Serializability.
  4. Discuss conflict Serializability.
  5. What is Recoverability?
  6. What are Schedules?
  7. What are differences between conflict serializability and view serializability ?
  8. What are cascadeless and recoverable schedules?
Unit 5

Concurrency Control Techniques

Open unit →
  1. Concurrency Control Techniques in DBMS
  2. Comparison between Single-User and Multi-User System
  3. Transactions in DBMS, Its states and ACID Properties
  4. ACID Properties Of Transaction in DBMS
  5. What is the need of Concurrency Control?
  6. Explanation of Lost Update Problem and Dirty Read Problem
  7. What Problem faced when Concurrent transactions are executing?
  8. Locking technique, Its Working, 2-phase locking and Comparison