MSSQL DAY-3

A ____ join returns only the rows where there is a match in both tables.

Joins are written in the ____ clause of a SQL statement.

The ____ keyword is used to rename a table in a join query.

You can join tables based on ____ keys.(It's Constraints)

Which JOIN returns all records from the left table, and the matched records from the right table?

• LEFT JOIN

• INNER JOIN

• RIGHT JOIN

• FULL JOIN

Which clause is used to specify the condition for joining two tables?

• SELECT

• WHERE

• ON

• HAVING

Which of the following is NOT a valid SQL JOIN?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• UPPER JOIN

The IDENTITY property can only be applied to columns with ____ data types.

Auto-increment columns are typically used for ____ keys.

What keyword is used to create an auto-incrementing column in SQL Server?

• AUTOINCREMENT

• SERIAL

• IDENTITY

• AUTOID