ICRA Analytics SQL Developer Interview Questions and Answers

Types of joins in SQL Server include inner join, left join, right join, and full outer join.

• Inner join: Returns rows when there is at least one match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in one of the tables

A super key is a set of attributes that uniquely identifies each tuple in a table.

• A super key can contain more attributes than necessary to uniquely identify a tuple.

• Example: {ID, Name} can be a super key for a table with attributes {ID, Name, Age}.

• Super keys are used in database design to ensure data integrity.