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,

1070

Explain what is meant by replication of database?

Cap Gemini,

1031

How to add additional conditions in SQL?

Amdocs,

1022

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

Cap Gemini,

1049

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

Agilent, Amdocs,

1677

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

Akamai Technologies,

1047

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

Akamai Technologies,

1078

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

Akamai Technologies,

1466

Benefits of Stored Procedures?

Wipro,

964

What are the advantages to use stored procedures?

Ernst Young,

1109

What is SQL Server?

Atos Origin,

1213

How can we improve performance by using SQL Server profiler?

QuestPond,

1053

How do you send email on SQL Server?

MindCracker,

1064

How to concatenate two strings in SQL Server.

HCL,

1149

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

MCN Solutions,

1001

Un-Answered Questions { SQL Server }

How to create prepared statements using odbc_prepare()?

1065

Explain data warehousing in sql server?

1048

What is an example of a primary key?

991

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1034

Do you know hot add cpu in sql server 2008?

952

What is difference between index and primary key?

1100

Tell me about joins in database system and explain each in detail.

1046

How do I perform an unattended install of sql server 2000?

1086

What are different backups available in sql server?

1070

How to stop log file growing too big?

1014

How will you add a dimension to cube? : sql server analysis services, ssas

1086

whats the maximum size of view state??

2192

How many types of the database links?

1070

Can we insert data into view sql server?

927

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

1120

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