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?
Our Learners Work At

AfterAcademy

Stay up to date. Follow us on