DBT Interview Questions For Freshers

What is a join in SQL?

Summary:

Detailed Answer:

What is a foreign key in a database?

Summary:

Detailed Answer:

What is normalization in DBMS?

Summary:

Detailed Answer:

What are the ACID properties of a database?

Summary:

Detailed Answer:

Explain the difference between a database and a spreadsheet.

Summary:

Detailed Answer:

What is a transaction in a database?

Summary:

Detailed Answer:

What is indexing in database management systems?

Summary:

Detailed Answer:

What is a SQL query?

Summary:

Detailed Answer:

What is a database schema?

Summary:

Detailed Answer:

What is the purpose of a primary key in a database?

Summary:

Detailed Answer:

What is the purpose of a database trigger?

Summary:

Detailed Answer:

What is the difference between DELETE and TRUNCATE in SQL?

Summary:

Detailed Answer:

DBT Intermediate Interview Questions

What are the advantages and disadvantages of using an ORM (Object-Relational Mapping) framework?

Summary:

Detailed Answer:

What is a clustered index?

Summary:

Detailed Answer:

What is the purpose of the GROUP BY clause in SQL?

Summary:

Detailed Answer:

What is the difference between a primary key and a unique key in a database?

Summary:

Detailed Answer:

Explain the difference between a self join and an inner join in SQL.

Summary:

Detailed Answer:

Explain the concept of database replication.

Summary:

Detailed Answer:

What is a subquery in SQL?

Summary:

Detailed Answer:

Explain the concept of database normalization.

Summary:

Detailed Answer:

What are the different types of database indexes?

Summary:

Detailed Answer:

What is a deadlock in a database?

Summary:

Detailed Answer:

What is a stored procedure in a database?

Summary:

Detailed Answer:

What is the difference between UNION and UNION ALL in SQL?

Summary:

Detailed Answer:

DBT Interview Questions For Experienced

Explain the concept of eventual consistency in distributed databases.

Summary:

Detailed Answer:

What is the CAP theorem in database systems?

Summary:

Detailed Answer:

Why would you choose a NoSQL database over a relational database?

Summary:

Detailed Answer:

What is sharding in database architecture?

Summary:

Detailed Answer:

What is a materialized view in a database?

Summary:

Detailed Answer:

What are the characteristics of a distributed database?

Summary:

Detailed Answer:

What is a data warehouse?

Summary:

Detailed Answer:

Explain the difference between horizontal and vertical partitioning in database systems.

Summary:

Detailed Answer:

What is the purpose of a distributed transaction in database systems?

Summary:

Detailed Answer:

What is the difference between a bitmap index and a B-tree index in database systems?

Summary:

Detailed Answer:

Explain the concept of database sharding and its advantages.

Summary:

Detailed Answer:

What is the purpose of an MVCC (Multi-Version Concurrency Control) in database systems?

Summary:

Detailed Answer: