SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 11543

What are functions

3 9109

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

4 34122

What command do we use to rename a db?

IBM,

5 11330

What are the four main query statements?

Wipro,

7 19181

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

3 14452

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

2 19087

What is SQL server agent?

HCL, SAP Labs,

2 8220

What is the purpose of UPDATE STATISTICS?

2 11852

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

3 7232

Difference between Function and Stored Procedure?

C1 India, NA,

9 18579

What is data integrity? Explain constraints?

Thinksoft,

1 24686

Explain some DBCC commands?

6 17511

What are tasks?

Wipro,

3 10786

What is the purpose of using COLLATE in a query?

1 17733


Un-Answered Questions { SQL Server }

How to install sql server 2005 express edition?

519


Explain transaction server auto commit?

477


What are truncate options available in sql server? : sql server database administration

518


Can we use where clause with group by?

451


How do we synchronize On-Premise SQL server with SQL Azure?

90






List some of the rules that apply to creating and using a ‘view’

433


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

430


What is inner join in sql server joins?

478


What is Replication?

538


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

464


Tell me about the approaches which you used to counter the DI problems.

637


what is a correlated sub-query? : Sql server database administration

423


Explain what is use of dbcc commands?

440


What are the diifferences between the ms sql server vs mysql?

571


What are the steps you can take to avoid “deadlocks”?

463