What is the primary purpose of joining in data processing?

• To combine data from multiple sources

• To encrypt data for security

• To delete unnecessary data

• To separate data into different tables

Which type of join includes all records from the left table and matched records from the right table?

• Right Join

• Full Join

• Inner Join

• Left Join

In which scenario would you use a full join?

• When you need records from the left table only

• When you need all records from both tables

• When you need only matched records

• When you need records from the right table only

What is a common use case for using joins in databases?

• To create backups of data

• To perform data encryption

• To enhance data security

• To retrieve related data from multiple tables

Which join type would you use to ensure no data is lost from either table?

• Left Join

• Inner Join

• Right Join

• Full Join