1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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

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