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 web server?

Satyam,

3 25683

What are functions

3 22884

how to get the automatic backup of the database in the sql server

4 36181

What command do we use to rename a db?

IBM,

5 13930

What are the four main query statements?

Wipro,

7 22247

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 16146

What is the STUFF function and how does it differ from the REPLACE function?

2 20729

What is SQL server agent?

HCL, SAP Labs,

2 9963

What is the purpose of UPDATE STATISTICS?

2 13910

What is de-normalization and when do you do it?

3 9052

Difference between Function and Stored Procedure?

C1 India, NA,

9 22186

What is data integrity? Explain constraints?

Thinksoft,

1 26104

Explain some DBCC commands?

6 20191

What are tasks?

Wipro,

3 13375

What is the purpose of using COLLATE in a query?

1 18845

Un-Answered Questions { SQL Server }

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1996

What is the maximum rows in sql server table?

911

What are the advantages of the mirroring?

1094

Write a SQL query in order to merge two different columns into single column?

1036

Explain the use of containers in ssis?

966

How to create prepared statements using odbc_prepare()?

1065

How you trouble shoot when any job fails

1937

How to create an index on an existing table in ms sql server?

981

How to use group functions in the select clause in ms sql server?

1052

What are Row versions of DataRow?

1028

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1089

What is change tracking in sql server?

1025

Detail about the hardware which is supported by SQL server?

1063

What are the differences between local and global temporary tables?

1082

Can you name a few encryption mechanisms in sql server?

942

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