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 to check if a User database is locked?

TCS,

1021

Explain what is meant by replication of database?

Cap Gemini,

959

How to add additional conditions in SQL?

Amdocs,

974

What is the optimization being performed in oracle and SQL Server?

Cap Gemini,

999

write an SQL query to list the employees who joined in the month of January?

Agilent, Amdocs,

1624

Is BCNF better than 2NF & 3NF? Why?

Akamai Technologies,

1002

Write an SQL query to obtain the 2nd highest salary.

Akamai Technologies,

1022

Explain various On-Delete options in a DB table. Which is the default option?

Akamai Technologies,

1406

Benefits of Stored Procedures?

Wipro,

918

What are the advantages to use stored procedures?

Ernst Young,

1034

What is SQL Server?

Atos Origin,

1150

How can we improve performance by using SQL Server profiler?

QuestPond,

987

How do you send email on SQL Server?

MindCracker,

1003

How to concatenate two strings in SQL Server.

HCL,

1082

In which format does an image save in SQL Server database ?

MCN Solutions,

949

Un-Answered Questions { SQL Server }

Explain what is use of dbcc commands?

993

What is blocking?

984

What is inner join? Explain with an example?

1120

what are constraints? : Sql server database administration

984

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1069

What are the encryption mechanisms in sql server?

970

How to test odbc dsn connection settings?

969

What different steps will a sql server developer take to secure sql server?

932

How to generate create procedure script on an existing stored procedure?

940

What happens if time-only values are provided as date and time literals?

954

What is a view in sql?

929

What are character string data types in ms sql server?

1144

What is usually the first word in a sql query?

1073

How to use “drop” keyword in sql server and give an example?

1091

What is use of except clause?

1036

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