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 different types of backups available in sql server? : Sql server database administration

935

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1069

what happens on checkpoint? : Sql server database administration

1102

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984

explain the storage models of olap? : Sql server database administration

959

how to create a scrollable cursor with the scroll option? : Sql server database administration

1092

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

909

what is create database syntax? : Sql server database administration

1105

what type of index will get created after executing the above statement? : Sql server database administration

971

what authentication modes does sql server support? : Sql server database administration

1109

how many layers of tcp/ip protocol combined of? : Sql server database administration

997

what is dbcc? : Sql server database administration

1033

how to define testing of network layers? : Sql server database administration

972

is there a column to which a default can't be bound? : Sql server database administration

1015

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1055

Un-Answered Questions { SQL Server }

How can you start sql server in different modes?

971

What are the functions in sql server?

947

Explain the microsoft sql server delete command? : SQL Server Architecture

1084

System variable and temporary variables

2250

Differentiate between truncate vs delete in mssql?

1083

What does executeupdate return?

977

Why truncate is ddl?

1088

What are sql dirty pages?

1024

What is implicit cursors?

1085

what is datawarehouse?

1114

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1163

What is an execution plan?

1151

What is failover clustering overview?

1088

What is inner join? Explain with an example?

1222

How can we call UDF(User Define Function) using C# code in ASP.net ?

6886

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