Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What are the differences between UNION and JOINS in SQL Server?

JOIN:- A join selects columns from 2 or more tables.

UNION:- A union selects rows.



Next 5 interview question(s)

1
Explain the difference between text and image data type?
2
What are the data types in SQL Server?
3
What is fill factor in SQL Server?
4
What is sorting and what is the difference between sorting & clustered Indexes?
5
Difference between Index defrag and Index rebuild in SQL Server?