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 a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

864

what are the types of indexes? : Sql server database administration

1076

what kind of lan types do you know? : Sql server database administration

942

what's the difference between delete table and truncate table commands? : Sql server database administration

943

what are user defined datatypes? : Sql server database administration

936

explain databases and sql server databases architecture? : Sql server database administration

924

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

933

do you know how to configure db2 side of the application? : Sql server database administration

1001

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1044

how to determine the service pack currently installed on sql server? : Sql server database administration

930

what are the different types of replication you can set up in sql server? : Sql server database administration

988

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

1055

what are triggers? : Sql server database administration

880

what are cursors? : Sql server database administration

1017

what's sql server? : Sql server database administration

941

Un-Answered Questions { SQL Server }

What is create statement?

902

What are the disadvantages of indexes?

1019

What is proper subset of candidate key?

953

What types of replication are supported in sql server?

1015

What are the limitations/drawbacks or ssrs 2008 r2?

135

What happens to a trigger with multiple affected rows?

891

What is built-in/administrator?

967

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

948

Does the unique constraint create an index?

1006

How to get a list of columns using the "sys.columns" view in ms sql server?

926

What is database replication? What are the different types of replication you can set up in sql server?

922

How can you control the amount of free space in your index pages?

1027

What is create command?

939

Relational calculus is what type of language?

982

Is foreign key unique?

961

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