SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 8844

What are functions

3 6745

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

4 31939




What command do we use to rename a db?

IBM,

5 8729

What are the four main query statements?

Wipro,

7 15484

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

3 12389

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

2 17366

What is SQL server agent?

HCL, SAP Labs,

2 6389

What is the purpose of UPDATE STATISTICS?

2 10291

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

3 5630

Difference between Function and Stored Procedure?

C1 India, NA,

9 15068

What is data integrity? Explain constraints?

Thinksoft,

1 22354

Explain some DBCC commands?

6 14496

What are tasks?

Wipro,

3 8528

What is the purpose of using COLLATE in a query?

1 16548







Un-Answered Questions { SQL Server }

What is the difference between varchar and varchar(max) datatypes?

22


What are the dmvs?

38


What is SQL Azure Fabric?

7


What is a covered index?

25


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

27






What is the difference between insensitive and scroll cursor?

20


How to stop log file growing too big?

22


How to invoke a trigger on demand?

10


What are basics of policy management?

24


Explain raiserror in sql server?

23


How to find out the list schema name and table name for the database?

27


What is shared lock?

13


What is lookup override?

36


Can binary strings be used in arithmetical operations?

20


How can you know if the row fetched from cursor is still valid in underlying table?

25