SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 9373

What are functions

3 7029

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

4 32177

What command do we use to rename a db?

IBM,

5 9003

What are the four main query statements?

Wipro,

7 15826

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

3 12607

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

2 17637

What is SQL server agent?

HCL, SAP Labs,

2 6566

What is the purpose of UPDATE STATISTICS?

2 10470

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

3 5780

Difference between Function and Stored Procedure?

C1 India, NA,

9 15448

What is data integrity? Explain constraints?

Thinksoft,

1 22751

Explain some DBCC commands?

6 14872

What are tasks?

Wipro,

3 8836

What is the purpose of using COLLATE in a query?

1 16698







Un-Answered Questions { SQL Server }

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

80


What is the maximum size of sql server database?

48


Tell me what is difference between view and materialized view?

95


What is data modification?

46


what is the difference between Tabular and Matrix report?

15






What is database replication? What are the different types of replication you can set up in sql server?

96


Explain boyce and codd normal form(bcnf)?

78


How do users use Report Builder with SQL Server data sources?

11


What is user-defined scalar function?

79


What are the different types of cursor?

95


Is the log file is a part of file group?

103


How can you swap values between two rows in a table using single- SQL statement?

111


What are the advantages of passing name-value pairs as parameters?

81


Tell me in brief how sql server enhances scalability of the database system?

73


How do I find query history in sql server?

54