Question 1
What is the purpose of an index in a database table?
Question 2
What does the ACID acronym describe in the context of database transactions?
Question 3
What is database normalization primarily intended to reduce?
Question 4
What does an INNER JOIN return?
Question 5
What is a primary key in a relational database table?
Question 6
What does the SQL GROUP BY clause do?
Question 7
What does a foreign key constraint enforce between two tables?
Question 8
What SQL keyword combines the result sets of two SELECT statements, removing duplicates by default?
Question 9
What does a LEFT JOIN return that an INNER JOIN would not?
Question 10
Which SQL clause is used to filter rows before any grouping occurs?