SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 8511

What are functions

3 6585

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

4 31814




What command do we use to rename a db?

IBM,

5 8569

What are the four main query statements?

Wipro,

7 15175

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

3 12251

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

2 17193

What is SQL server agent?

HCL, SAP Labs,

2 6292

What is the purpose of UPDATE STATISTICS?

2 10142

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

3 5538

Difference between Function and Stored Procedure?

C1 India, NA,

9 14842

What is data integrity? Explain constraints?

Thinksoft,

1 22091

Explain some DBCC commands?

6 14229

What are tasks?

Wipro,

3 8348

What is the purpose of using COLLATE in a query?

1 16357







Un-Answered Questions { SQL Server }

How to delete duplicate records based on single column from a table?

13


How many null values we can have in a unique key field in sql server?

1


What do you mean by subquery?

1


What is the use of tempdb? What values does it hold?

19


What is reportserver and reportservertempdb ?

1






What is SQL Azure Data sync?

1


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

11


What are the types of database recovery models?

5


wat wil hapn if we give the both read and deny read permission to user?

1080


what are the different stages of Report Processing?

1


What are the Advantages of using CTE in sql server?

11


What does REVERT do in SQL Server 2005?

15


What new changes are being made in SQL Server?

13


role of sql sever 2005 in database rather than any other database

985


Explain about service Broker functions?

7