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

explain different levels of normalization? : Sql server database administration

952

how many bits ip address consist of? : Sql server database administration

860

what's the difference between a primary key and a unique key? : Sql server database administration

907

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

943

why would you call update statistics? : Sql server database administration

1035

what types of replication are supported in sql server? : Sql server database administration

979

what is bit datatype? : Sql server database administration

875

what is a self join? Explain it with an example? : Sql server database administration

897

what is denormalization and when would you go for it? : Sql server database administration

1129

what is database replication? : Sql server database administration

1008

what is raid? : Sql server database administration

989

what is an index? : Sql server database administration

945

explain different types of backups avaialabe in sql server? : Sql server database administration

936

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

919

how to trace the traffic hitting a sql server? : Sql server database administration

1810

Un-Answered Questions { SQL Server }

How do I find information about the install locations for the various instances running on a computer?

1043

Can we install sql server 2016 on windows 7?

1088

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1010

How is sql server used?

922

Define msdb database?

987

Define inner join in sql server joins?

1001

Why is replication required on the sql server?

1021

What do you mean by data integrity?

1015

What is enhanced database mirroring in sql server 2008?

929

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

848

How to list all stored procedures in the current database using ms sql server?

1075

What is store procedure?

1019

How do I run sql server 2014?

950

Is sql server 2016 free?

893

What is the importance of a recovery model?

1015

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