Theoretical Questions on DBMS

DBMS - Database Management System. Here, we have listed all the commonly asked questions during the tech interview on DBMS

Theoretical Questions on DBMS
#
Title
1 .
What is a Database and DBMS?
2 .
What is a Database Management System and how is it different from a File System?
3 .
What is the difference between RDBMS and DBMS?
4 .
What is Data Model in DBMS and what are its types?
5 .
What is Data Abstraction in DBMS and what are its three levels?
6 .
What is Data integrity?
7 .
What is Relational Algebra?
8 .
What is a Schema?
9 .
What is an E-R model?
10 .
What is an Entity, Entity type, and Entity set?
11 .
Differentiate between weak and strong entity.
12 .
What are the different types of relationships in DBMS?
13 .
What is the degree of relation in DBMS?
14 .
What is an attribute?
15 .
What is Normalization in DBMS?
16 .
What is Denormalization in DBMS?
17 .
What is Specialization in DBMS?
18 .
What is Generalization in DBMS?
19 .
What is SQL?
20 .
What is the difference between SQL and MySQL?
21 .
What is an embedded and dynamic SQL?
22 .
What is the difference between SQL and NoSQL?
23 .
What is the difference between SQL and SQL Server?
24 .
What are the different types of SQL commands?
25 .
What are various types of constraints in SQL?
26 .
What are Super key, Primary key, Candidate key, and Foreign keys?
27 .
What is the difference between Primary key and Unique key?
28 .
What is a Query and Subquery in DBMS?
29 .
What is Query optimization?
30 .
What is the difference between TRUNCATE, DELETE, and DROP statement?
31 .
What are aggregate functions?
32 .
What are scalar functions?
33 .
What is Join in DBMS and what are its types?
34 .
What is Self-join in DBMS?
35 .
What is Cross-join in DBMS?
36 .
What are UNION, MINUS, and INTERSECT commands in DBMS?
37 .
What is pattern matching in SQL and how it is done?
38 .
What is the difference between HAVING and WHERE clause?
39 .
What is View in SQL?
40 .
What is a Trigger in DBMS?
41 .
What is a Stored Procedure in DBMS?
42 .
Difference between Trigger and Stored procedure in DBMS.
43 .
What is a Deadlock in DBMS and what are the deadlock avoidance, detection, and prevention techniques?
44 .
What is a database cursor and how to use it?
45 .
What is a transaction? What are ACID properties?
46 .
What is the difference between OLTP and OLAP?
47 .
What is Data independency?
48 .
What is concurrency control in DBMS?
49 .
What is dirty read and unrepeatable read problem in DBMS?
50 .
What is a Phantom deadlock?
51 .
What is a checkpoint and when does it occur?
52 .
Differentiate between Clustered and non-Clustered indexes.
53 .
What are B trees?
54 .
What are B+ trees?

Connect With Your Mentors

/assets/ali.jpg
Janishar Ali
Founder | IIT-BHU | 10 Yrs Exp.
/assets/amit.jpg
Amit Shekhar
Founder | IIT-BHU | 10 Yrs Exp.