Top 20 mostly asked Questions of DBMS in interview

What is a DBMS, and how does it differ from a traditional file system? (asked in interviews by companies like Google, Microsoft, Amazon, Oracle)

What are the different types of relationships that can exist between tables in a database? (asked in interviews by companies like Facebook, IBM, Apple)

What is normalization, and how is it achieved in a database? (asked in interviews by companies like Accenture, Deloitte, PwC)

What are the different levels of data abstraction in a database system? (asked in interviews by companies like Infosys, Wipro, TCS)

What is ACID, and why is it important in database transactions? (asked in interviews by companies like SAP, Intel, Cisco)

What is a primary key, and why is it important in database design? (asked in interviews by companies like LinkedIn, Airbnb, Uber)

What is a foreign key, and how is it used to establish relationships between tables? (asked in interviews by companies like Netflix, PayPal, Square)

What is a clustered index, and how is it different from a non-clustered index? (asked in interviews by companies like Salesforce, Dropbox, Twitter)

What is a view, and how is it used in a database? (asked in interviews by companies like IBM, HP, Siemens)

What is a stored procedure, and how is it different from a function? (asked in interviews by companies like Intel, Oracle, Microsoft)

What is a trigger, and how is it used in a database? (asked in interviews by companies like Amazon, Google, Microsoft)

What is a deadlock, and how can it be prevented in a database? (asked in interviews by companies like Facebook, Apple, Google)

What is a transaction, and what are the properties of a transaction? (asked in interviews by companies like Accenture, Deloitte, PwC)

What is a database schema, and how is it different from a database instance? (asked in interviews by companies like Infosys, Wipro, TCS)

What is indexing, and how is it used to improve database performance? (asked in interviews by companies like SAP, Intel, Cisco)

What is SQL, and how is it used to interact with a database? (asked in interviews by companies like LinkedIn, Airbnb, Uber)

What are the different types of joins in SQL, and how are they used to combine data from multiple tables? (asked in interviews by companies like Netflix, PayPal, Square)

What is a subquery, and how is it used in SQL? (asked in interviews by companies like Salesforce, Dropbox, Twitter)

What is normalization, and how is it achieved in a database? (asked in interviews by companies like IBM, HP, Siemens)

What is a NoSQL database, and how is it different from a traditional relational database? (asked in interviews by companies like Amazon, Google, Microsoft)