CLEAN : Paris art landmark hosts drive in movie

What is the primary purpose of a 'Join' in data operations?

• To create a backup of data

• To sort data in ascending order

• To delete data from a table

• To merge data from multiple sources

Which type of join would you use to include all records from both tables, even if there is no match?

• Inner Join

• Left Join

• Right Join

• Full Outer Join

In which scenario would a 'Left Join' be most appropriate?

• When you need only matching records from both tables

• When you need all records from the right table and matching ones from the left

• When you need all records from the left table and matching ones from the right

• When you need to exclude all unmatched records

What is a common use case for using a 'Join' in database management?

• To update records in a single table

• To encrypt sensitive data

• To delete duplicate records

• To combine data from related tables for reporting

Which join type is best for retrieving only the records that have matching values in both tables?

• Inner Join

• Left Join

• Right Join

• Cross Join