All Topics
Topic8 questions
SQLQuestions & Answers
Practice 8 SQL questions with detailed answers and explanations. Tap any question below to study the full solution.
SQL question list
What is the difference between WHERE and HAVING clauses in SQL?Which constraints does a PRIMARY KEY automatically enforce?What rows does a LEFT JOIN return that an INNER JOIN does not?What is the key difference between DELETE and TRUNCATE in SQL?How do aggregate functions like COUNT(), SUM(), and AVG() handle NULL values?In which scenario is a correlated subquery typically less efficient than a JOIN?A table is in Third Normal Form (3NF) when it satisfies which conditions?Which scenario benefits MOST from adding a database index?Practice more topics
PrimerPrep has independently reviewed practice questions and coding exercises — all free.