JOINS IN BIG DATA

Which of the following JOINs returns only matching rows between two tables?

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

• FULL OUTER JOIN

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

• RIGHT JOIN

• LEFT JOIN

• INNER JOIN

• FULL OUTER JOIN

What type of JOIN would you use to retrieve all records from both tables, regardless of whether there is a match?

• FULL OUTER JOIN

• INNER JOIN

• RIGHT JOIN

• LEFT JOIN

Which JOIN type is used to combine rows from two or more tables based on a related column between them?

• OUTER JOIN

• CROSS JOIN

• INNER JOIN

• SELF JOIN

If Table A has 5 rows and Table B has 3 rows, what is the maximum number of rows a CROSS JOIN can return?

• 5

• 3

• 8

• 15

What does the USING clause do in a JOIN statement?

• specifies the condition on which the JOIN should happen

• Automatically joins tables based on common column names

• Filters the data before performing a JOIN

• Allows joining tables without specifying column names

If Table C has 4 rows and Table D has 6 rows, what is the maximum number of rows a CROSS JOIN can return?

• 24

• 10

• 6

• 4

Which JOIN type returns all rows from the right table and the matched rows from the left table?

• RIGHT JOIN

• INNER JOIN

• FULL OUTER JOIN

• LEFT JOIN

What is the purpose of the ON clause in a JOIN statement?

• Defines the columns to be selected from the tables

• Specifies the condition for the JOIN operation

• Filters the results after the JOIN is performed

• Automatically matches columns with the same name

Which JOIN is best for finding unmatched records in two tables?