SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 12991

What are functions

3 10136

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

4 35148

What command do we use to rename a db?

IBM,

5 12639

What are the four main query statements?

Wipro,

7 20895

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

3 15338

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

2 19918

What is SQL server agent?

HCL, SAP Labs,

2 8975

What is the purpose of UPDATE STATISTICS?

2 12990

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

3 8124

Difference between Function and Stored Procedure?

C1 India, NA,

9 20298

What is data integrity? Explain constraints?

Thinksoft,

1 25433

Explain some DBCC commands?

6 18844

What are tasks?

Wipro,

3 12203

What is the purpose of using COLLATE in a query?

1 18271


Un-Answered Questions { SQL Server }

Do you know how to send email from database?

773


What are scalar functions in sql?

857


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5725


What is the function of inner join?

801


How to change the password of a login name in ms sql server?

760


What is the minimum recommended amount of ram for sql server 2012 enterprise?

729


Explain different types of lock modes in sql server 2000?

726


How to apply filtering criteria at group level with the having clause in ms sql server?

793


How to disable stored procedure sql server?

1278


What is a trigger? Why we need it?

743


Define indexes?

832


Where views are stored in sql server?

767


What is mean by dml?

774


What is the difference between truncate and delete commands?

782


Is the log file is a part of file group?

762