In SQL, which type of JOIN returns only the common rows between two tables?
What is the purpose of the SQL CASE statement?
Which SQL statement is used to add a new column to an existing table?
What is the primary key in an SQL table used for?
Which SQL aggregate function would you use to find the total number of rows in a table?
What does the SQL term "Normalization" refer to?
What is the purpose of the SQL UNION operator?
In SQL, what is a subquery?
What is the purpose of the SQL INDEX?
Which SQL clause is used to filter the results of a SELECT statement based on multiple conditions?
Which SQL command is used to remove all data from a table?
What is the difference between UNION and UNION ALL in SQL?
Which SQL statement is used to retrieve the second highest value in a column?
What is the purpose of the SQL TRIGGER?