SQL Session 2 Quiz

What does INNER JOIN in SQL do?

• • Retrieves all rows from both tables

• Retrieves only matching rows from both tables

• Retrieves only rows from the left table

• Retrieves only rows from the right table

Only single WHEN statement can be included in CASE statement

• True

• False

Which is the default join type in SQL?

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

• OUTER JOIN

Which of the following JOINs returns all rows from the left table and matching rows from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

In a LEFT JOIN, what happens if there is no match in the right table?

• No rows are returned

• All rows from the right table are returned with NULL values for columns from the left table

• All rows from the left table are returned with NULL values for columns from the right table

• An error is thrown

Which JOIN returns all rows when there is a match in either the left or right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

How is the CASE statement used in a SELECT clause?

• To filter rows in the WHERE clause

• To define conditions and return values based on them

• To sort the result set

• To join multiple tables

Which of the following is the correct syntax for a simple CASE statement?

• CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 END

• CASE WHEN condition THEN result1 WHEN condition THEN result1 END

• ASE column WHEN value1 THEN result1 WHEN value2 THEN result2 END

• None of these

Every CASE statement must end with the END statement

• True

• False

What happens if none of the conditions in a CASE statement are true and there is no ELSE clause?

• An error is thrown

• The result is NULL

• The default value is returned

• The query executes successfully with an empty result set