SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What are pessimistic lock and optimistic lock?

1146

What is table constraint?

1054

What is sqlcmd?

1141

Explain activity monitors

1132

What is after dml trigger?

1063

What is dirty read?

1139

What is temporary table in sql server? Why we use temp table?

997

what is spatial nonclustered index

1043

Explain system functions or built-in functions? What are different types of system functions?

1045

What is standby servers? Explain types of standby servers.

1062

What is self contained sub query?

1126

What is a scheduled job or what is a scheduled task?

1012

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1013

What is clustered index

1067

Disadvantages of the indexes?

1194

Un-Answered Questions { SQL Server }

What is an indexing technique?

990

Why truncate is ddl?

1137

Can you explain what are commit and rollback in sql?

987

What is the use of keyword with encryption.

1088

What are a scheduled jobs or what is a scheduled tasks?

951

What does it mean to normalize data?

999

What is subquery? Explain the properties of a subquery?

1042

What do you mean by subquery?

1154

What is equi join with example?

1233

How to find out what is the default collation in a database?

1183

what are triggers? : Sql server database administration

955

If no size is defined while creating the database, what size will the database have?

1038

How optimize sql query with multiple joins in sql server?

959

What is sharding?

116

Write a SQL query to make a column as unique?

1078

For More Un-Answered { SQL Server } Questions Click Here