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 the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

QuestPond,

1062

What is the default port for SQL Server over a firewall?

Microsoft,

1033

What is the syntax for encrypting a column in SQL Server?

MindCracker,

1060

what is difference between NULL and ISNULL in SQL Server 2008?

MCN Solutions,

967

How to create a Master database in SQL server ?

MCN Solutions,

1023

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

MCN Solutions,

1133

Difference between LEN() and DATALENGTH() in sql server ?

HCL,

1062

Show Practically Sql Server Views are updatable?

QuestPond,

1056

Define tool Manage Statistics in SQL Server 2000 query ?

NA,

1026

What is dynamic cursor in SQL SERVER?

1003

How you can change the database name in SQL SERVER?

1136

how we use window authentication connection with sql server.?

MCN Solutions,

1087

How display code or Text of Stored Procedure using Sql query in Sql Server ?

Wipro,

1070

Difference between connected and disconnected database in .net with sql server?

Infosys,

1037

Give the query of getting last two records from the table in SQL SERVER?

Petranics Solutions,

901

Un-Answered Questions { SQL Server }

What is the process of normalization?

1059

How many database files are there in sql server 2000?what are they?

980

What are sql azure firewall rules?

106

How do you clear a log file?

985

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1016

Does any body please help me what question's have asked for SSRS in the interview?

2087

How many categories of functions based their return modes?

1063

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1758

What is the difference between varchar and varchar types?

1005

What is the size of transaction log file?

871

Explain left outer join and right outer join?

974

What is an execution plan?

1059

What is the difference between char, varchar and nvarchar?

980

What is the Difference Between Primary and Foreign Key?

960

How do you know if sql server is running on your local system?

977

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