Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

Disadvantage of Index in SQL Server?

Every Index increases the time in takes to perform INSERT's, UPDATE's and DELETE's. So the number of indexes should not be very much.




Next 5 interview question(s)

1
What do you mean by ACID?
2
Explain the difference between a Local and a Global temporary table?
3
What is the difference between UNION and UNION ALL?
4
What are the authentication modes in SQL Server?
5
What are the properties and different Types of Sub-Queries?