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?

1141

What is table constraint?

1052

What is sqlcmd?

1136

Explain activity monitors

1129

What is after dml trigger?

1062

What is dirty read?

1135

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

993

what is spatial nonclustered index

1036

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

1041

What is standby servers? Explain types of standby servers.

1054

What is self contained sub query?

1120

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

1008

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

1010

What is clustered index

1059

Disadvantages of the indexes?

1183

Un-Answered Questions { SQL Server }

What is the new security features added in sql server 2014? : sql server security

1049

What command is used to create a database in the sql server and how?

1241

How to insert multiple rows with one insert statement in ms sql server?

1180

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1023

How to round a numeric value to a specific precision?

1126

What is the difference between mysql and mysqli?

1286

How to enable/disable indexes?

1123

How to convert character strings into numeric values?

1146

how to control the amount of free space in your index pages? : Sql server database administration

1085

explain different types of cursors? : Sql server database administration

1146

How to name query output columns in ms sql server?

1014

What is dml command?

1019

Which command is used for user defined error messages?

1104

What is full outer join in sql server joins?

1139

How do I view a script in sql server?

1087

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