Interview Questions on DBMS for software engineer

 Basic DBMS Interview Questions 

1.  What is meant by DBMS and what is its utility? Explain RDBMS with examples. 

2.  What is meant by a database? 

3.  Mention the issues with traditional file-based systems that make DBMS a better choice? 

4.  Explain a few advantages of a DBMS. 

5.  Explain the different languages present in DBMS. 

6.  What is meant by ACID properties in DBMS? 

7.  Are NULL values in a database the same as that of blank space or zero? Intermediate DBMS Interview Questions 

8.  What is meant by Data Warehousing? 

9.  Explain different levels of data abstraction in a DBMS. 

10.  What is meant by an entity-relationship (E-R) model? Explain the terms Entity, Entity Type, and Entity Set in DBMS. 

11.  Explain different types of relationships amongst tables in a DBMS. 

12.  Explain the difference between intension and extension in a database. 

13.  Explain the difference between the DELETE and TRUNCATE commands in a DBMS. 

14.  What is a lock. Explain the major difference between a shared lock and an exclusive lock during a transaction in a database. 

15.  What is meant by normalization and denormalization? 

Advanced DBMS Interview Questions 

16.  Explain different types of Normalization forms in a DBMS. 

17.  Explain different types of keys in a database.

18.  Explain the difference between a 2-tier and 3-tier architecture in a DBMS.