PL: Q2-Lesson5 IT2101

What does the INNER JOIN do in MySQL?

• Combines rows from two or more tables based on a related column

• Produces the Cartesian product of two tables

• Retrieves all records from the left table

• Retrieves all records from the right table

What is the result of a LEFT JOIN when there is no match?

• No records are returned

• Only records from the right table are returned

• All records from the left table are returned with NULLs for the right table

• Only matched records are returned

What does a RIGHT JOIN in MySQL retrieve?

• No records if there is no match

• Only matched records from both tables

• All records from the right table and matched records from the left table

• All records from the left table and matched records from the right table

What is the purpose of a CROSS JOIN?

• To filter records based on conditions

• To retrieve all records from one table

• To produce the Cartesian product of two tables

• To combine rows based on a related column

Which type of JOIN includes NULL values for unmatched records from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• CROSS JOIN

What is a characteristic of INNER JOIN?

• It retrieves all records from both tables

• It only retrieves rows with matches in both tables

• It does not require a joining condition

• It retrieves all records from the left table

In which scenario is a CROSS JOIN typically used?

• When you want to filter records based on conditions

• When you want to combine every row from one table with every row from another

• When you want to retrieve all records from one table

• When you want to match records from two tables

What happens in a LEFT JOIN if there are no matches in the right table?

• Only records from the right table are returned

• Only matched records are returned

• All records from the left table are returned with NULLs for the right table

• No records are returned

Which JOIN type is most commonly used in relational databases?

• LEFT JOIN

• CROSS JOIN

• RIGHT JOIN

• INNER JOIN

What does a RIGHT JOIN include when there is no match?

• No records at all

• Rows from the right table with NULLs for the left table

• Only matched records

• Rows from the left table with NULLs for the right table