DBMS Viva Questions with Answers (For Exams)

Introduction

Database Management System (DBMS) is a core subject for computer science students and is frequently asked in exams, viva, and interviews. Understanding DBMS concepts clearly will help you score high and build a strong foundation for backend development.

In this article, you will learn important DBMS viva questions with answers that are commonly asked in college exams and technical interviews.

---

What is DBMS

A Database Management System (DBMS) is software that allows users to store, manage, and retrieve data efficiently.

Examples include MySQL, PostgreSQL, and Oracle.

---

Basic DBMS Viva Questions

1. What is a database

A database is a collection of organized data that can be easily accessed, managed, and updated.

---

2. What is DBMS

DBMS is software used to manage databases and perform operations like insert, update, delete, and retrieve data.

---

3. What are the advantages of DBMS

• Reduces data redundancy
• Improves data consistency
• Provides data security
• Allows multi-user access

---

4. What is data redundancy

Data redundancy means duplication of data in multiple places, which can cause inconsistency.

---

5. What is data integrity

Data integrity ensures that the data stored in the database is accurate and consistent.

---

Intermediate DBMS Questions

6. What is a primary key

A primary key is a unique identifier for each record in a table.

Example: Student ID

---

7. What is a foreign key

A foreign key is used to link two tables together.

---

8. What is normalization

Normalization is the process of organizing data to reduce redundancy and improve efficiency.

---

9. What are normal forms

Normal forms are rules used in normalization.

Types:

• 1NF
• 2NF
• 3NF

---

10. What is SQL

SQL (Structured Query Language) is used to communicate with databases.

---

SQL Viva Questions

11. What is SELECT statement

Used to retrieve data from a database.

SELECT * FROM students;

---

12. Difference between WHERE and HAVING

• WHERE filters rows
• HAVING filters groups

---

13. What is JOIN

JOIN is used to combine rows from multiple tables.

Types:

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN

---

14. What is GROUP BY

Used to group rows with same values.

---

15. What is ORDER BY

Used to sort results.

---

Advanced DBMS Viva Questions

16. What is indexing

Indexing improves the speed of data retrieval.

---

17. What is transaction

A transaction is a sequence of operations performed as a single unit.

---

18. What are ACID properties

• Atomicity: All or nothing
• Consistency: Valid data
• Isolation: Independent execution
• Durability: Permanent storage

---

19. What is concurrency control

It manages simultaneous operations without conflict.

---

20. What is deadlock

A situation where two transactions wait for each other indefinitely.

---

Important Conceptual Questions

21. Difference between DBMS and RDBMS

• DBMS stores data as files
• RDBMS stores data in tables with relationships

---

22. What is a schema

Schema is the structure of a database.

---

23. What is a table

A table is a collection of rows and columns.

---

24. What is a tuple

A tuple is a single row in a table.

---

25. What is an attribute

An attribute is a column in a table.

---

Viva Tips for Students

• Always give short and clear answers
• Use examples where possible
• Understand concepts instead of memorizing
• Practice SQL queries
• Stay confident during viva

---

Common Viva Mistakes

• Giving long confusing answers
• Not knowing basic definitions
• Confusing keys and relationships
• Ignoring SQL practice