Question 1: SQL Definition and Purpose
What is SQL, and why is it used?
Question 2: Database vs Table Distinction
What is the difference between a database and a table?
Question 3: Selecting All Columns
Which query retrieves all columns from the students table?
Question 4: Filtering Rows with WHERE
Write a query to find all employees whose department is 'HR'.
Question 5: Primary Key vs Unique Key
What is the difference between primary key and unique key?
Question 6: Sorting Results
Which query returns student names in ascending order?
Question 7: Foreign Key Concept
What is a foreign key?
Question 8: SQL Constraints Overview
What are constraints in SQL?
Question 9: NULL vs 0 Distinction
What is the difference between NULL and 0?
Question 10: Counting Rows
Which query counts the total number of students in the students table?