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

1003

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

899

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

950

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

990

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

1088

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

1046

what is bit datatype? : Sql server database administration

917

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

948

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

1188

what is database replication? : Sql server database administration

1063

what is raid? : Sql server database administration

1039

what is an index? : Sql server database administration

982

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

968

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

956

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

1879

Un-Answered Questions { SQL Server }

How to restore performance issues and how to check?

2003

How to connect Azure federated root database and apply federation in entity framework?

107

Write a SQL command to insert and update only a particular field?

1110

What are cursors stored procedures and triggers?

1021

What methods do you follow to protect from sql injection attack?

1029

How do I create a trace in sql server?

1041

Explain syntax for dropping triggers?

928

Explain having clause and where clause?

1055

Why use sub query in sql server and list out types of sub queries?

1000

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

What is the purpose of update statistics and scope_identity() function?

1100

How to transfer an existing table from one schema to another schema in ms sql server?

981

What is master database? : SQL Server Architecture

1019

Explain what is the difference between union and union all?

1009

What are clustered and non-clustered index?

1008

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