MS SQL Server - 26 - Joins MCQ

26 – Joins MCQ

Best of luck!

1 / 25

1. Which SQL clause is used to combine rows from two or more tables based on a related column between them?

GROUP BY

WHERE

HAVING

JOIN

2 / 25

2. In SQL Server, what is the purpose of a JOIN clause?

To combine rows from multiple tables

To perform calculations on columns

To create a new table

To filter rows from a single table

3 / 25

3. What is the result of a Cartesian product when joining two tables in SQL Server?

All possible combinations of rows from both tables

A summary of data from both tables

An error is thrown

A single row with combined data

4 / 25

4. Which SQL statement is used to perform a Natural Join in SQL Server?

INNER JOIN

UNION JOIN

NATURAL JOIN

CROSS JOIN

5 / 25

5. What is the main drawback of using a Natural Join in SQL Server?

It is slow and inefficient.

It relies on column names and can be error-prone.

It can only return NULL values.

It can only be used with two tables.

6 / 25

6. In SQL Server, which type of join returns all rows when there is a match in either the left or the right table?

FULL OUTER JOIN

LEFT JOIN

INNER JOIN

RIGHT JOIN

7 / 25

7. What is the result when performing an INNER JOIN between two tables with no matching rows in SQL Server?

All rows from the left table

An empty result set

An error is thrown

All rows from the right table

8 / 25

8. In SQL Server, which join type is represented by the keyword “LEFT JOIN”?

RIGHT JOIN

LEFT OUTER JOIN

OUTER JOIN

INNER JOIN

9 / 25

9. What does the ON clause specify in an SQL Server JOIN statement?

The conditions for joining the tables

The columns to be displayed in the result set

The columns used for sorting the result set

The maximum number of rows to retrieve

10 / 25

10. Which type of JOIN in SQL Server returns all rows from the left table, and the matched rows from the right table?

FULL OUTER JOIN

LEFT JOIN

INNER JOIN

RIGHT JOIN

11 / 25

11. What is the purpose of a CROSS JOIN in SQL Server?

To create a new table from the joined tables

To combine all rows from both tables without a condition

To combine rows based on a specified condition

To exclude rows based on a specified condition

12 / 25

12. In SQL Server, which type of JOIN returns only the rows where there is no match in the joined tables?

LEFT JOIN

RIGHT JOIN

INNER JOIN

ANTI JOIN

13 / 25

13. Which type of JOIN in SQL Server returns all rows from both tables with NULL values in places where there is no match?

LEFT JOIN

FULL OUTER JOIN

INNER JOIN

RIGHT JOIN

14 / 25

14. What is the result when performing a RIGHT JOIN between two tables with no matching rows in SQL Server?

An error is thrown

An empty result set

All rows from the left table

All rows from the right table

15 / 25

15. In SQL Server, which join type is represented by the keyword “RIGHT JOIN”?

INNER JOIN

OUTER JOIN

LEFT JOIN

RIGHT OUTER JOIN

16 / 25

16. Which type of JOIN in SQL Server returns only the rows with matching values in both tables?

LEFT JOIN

FULL OUTER JOIN

RIGHT JOIN

INNER JOIN

17 / 25

17. What is the result when performing a FULL OUTER JOIN between two tables with no matching rows in SQL Server?

All rows from the left table

An error is thrown

An empty result set

All rows from the right table

18 / 25

18. In SQL Server, what is a self-join?

A join that returns all rows from both tables

A join between two unrelated tables

A join between a table and a subquery

A join between a table and itself

19 / 25

19. What is the purpose of using aliases in JOIN statements in SQL Server?

To hide the columns from the result set

To create new columns in the result set

To specify which columns to join on

To give tables and columns shorter or more readable names

20 / 25

20. In SQL Server, which keyword is used to specify an alias for a table in a JOIN statement?

JOIN

TABLE

ALIAS

21 / 25

21. What is the result of a self-join in SQL Server?

An error is thrown

A NULL result set

A joined table with related rows

A Cartesian product

22 / 25

22. Which SQL keyword is used to combine rows from two or more tables based on a related column between them?

LINK

JOIN

CONNECT

CONCAT

23 / 25

23. In SQL Server, what is the result of performing a JOIN without specifying a condition in the ON clause?

An empty result set

All rows from the left table

A full Cartesian product of the tables

An error is thrown

24 / 25

24. In SQL Server, what is the primary difference between the INNER JOIN and OUTER JOIN clauses?

INNER JOIN combines all rows from both tables, while OUTER JOIN combines rows based on specified conditions.

INNER JOIN combines rows based on specified conditions, while OUTER JOIN combines all rows from both tables.

INNER JOIN is faster than OUTER JOIN.

INNER JOIN returns NULL values, while OUTER JOIN excludes NULL values.

25 / 25

25. Which type of JOIN in SQL Server combines all rows from both tables, filling in NULL values for unmatched rows?

INNER JOIN

LEFT JOIN

FULL OUTER JOIN

RIGHT JOIN

Your score is

MS SQL Server – 26 – Joins MCQ