database

MySQL Database

Database optimizations, Joins, indexing, and transactional locking mechanics critical for backend engineers.

Interview Questions

3 Total

Q1.

What is the difference between INNER JOIN and LEFT JOIN?

Easy

INNER JOIN returns records that have matching values in both tables. LEFT JOIN returns all records from the left table, and the matched records from the right table.

Q2.

How does Indexing improve query performance?

Medium

Indexes are special data structures associated with tables that allow the database engine to find specific rows much faster, similar to an index in a book.

Q3.

What are ACID properties in MySQL?

Hard

ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties guarantee that database transactions are processed reliably.