Question 1

What is the difference between WHERE and HAVING?

Accepted Answer

WHERE filters individual rows before grouping and can't reference aggregate functions; HAVING filters groups after GROUP BY and is meant for filtering on aggregate results like COUNT() or SUM().

Question 2

What does ACID stand for?

Accepted Answer

Atomicity, Consistency, Isolation, and Durability — the four guarantees a database transaction provides so that operations complete reliably even with failures or concurrent access.

🗄️ SQL & DatabaseInterview Questions

🗄️ SQL & Database
Interview Questions