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 25827

What are functions

3 23031

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

4 36363

What command do we use to rename a db?

IBM,

5 14141

What are the four main query statements?

Wipro,

7 22483

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

3 16306

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

2 20851

What is SQL server agent?

HCL, SAP Labs,

2 10121

What is the purpose of UPDATE STATISTICS?

2 14006

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

3 9216

Difference between Function and Stored Procedure?

C1 India, NA,

9 22519

What is data integrity? Explain constraints?

Thinksoft,

1 26214

Explain some DBCC commands?

6 20420

What are tasks?

Wipro,

3 13521

What is the purpose of using COLLATE in a query?

1 18941

Un-Answered Questions { SQL Server }

Explain the different types of joins?

1046

Explain different types of locks in sql server.

1134

Explain the truncate command?

1043

What is apply operator in sql?

1047

What are “lock” hints?

1108

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1006

What are the new features of sql server 2012 reporting service?

141

Explain what is the difference between a local and a global temporary table?

1048

What is scan table/view and seek table/view when its occurs? : sql server database administration

1100

What are date and time data types in ms sql server?

1166

How to achieve Paging of records in SQL SERVER?

1151

How to skip remaining statements in a loop block using continue statements?

1045

what's sql server? : Sql server database administration

1057

What is the maximum size of a row in sql server?

1010

Explain how to use linked server?

1033

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