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 is normalization? : Sql server database administration

1164

what is a traditional network library for sql servers? : Sql server database administration

1020

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1183

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1110

what is a transaction and what are acid properties? : Sql server database administration

1091

what's the information that can be stored inside a bit column? : Sql server database administration

1093

what is an extended stored procedure? : Sql server database administration

1112

what is the different types of backups available in sql server? : Sql server database administration

974

when would you go for denormalization? : Sql server database administration

911

what are defaults? : Sql server database administration

1163

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1050

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1120

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1015

what is sql server? : Sql server database administration

1046

what is denormalization? : Sql server database administration

975

Un-Answered Questions { SQL Server }

What are the different types of subquery?

1208

What is the difference between nvl and nvl2?

1034

How to delete existing rows in a table?

1255

Does partitioning improve performance?

1023

What is the chart in report?

165

what protocol both networks use? : Sql server database administration

1020

What is raid and what are different types of raid levels?

1198

What are wait types?

1205

What are diverse clauses that form a part of sql?

1115

What is the purpose of forms?

1006

How to use clusters?

1020

explain what is raid and what are different types of raid configurations? : Sql server database administration

1056

Can you please explain the difference between function and stored procedure?

1049

How to find index size for each index on table?

1058

What does asynchronous call backs means?

1238

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