SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 11720

What are functions

3 9256

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

4 34274

What command do we use to rename a db?

IBM,

5 11530

What are the four main query statements?

Wipro,

7 19408

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

3 14609

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

2 19203

What is SQL server agent?

HCL, SAP Labs,

2 8346

What is the purpose of UPDATE STATISTICS?

2 11959

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

3 7361

Difference between Function and Stored Procedure?

C1 India, NA,

9 18823

What is data integrity? Explain constraints?

Thinksoft,

1 24866

Explain some DBCC commands?

6 17691

What are tasks?

Wipro,

3 10935

What is the purpose of using COLLATE in a query?

1 17809


Un-Answered Questions { SQL Server }

How to execute a sql statement using mssql_query()?

518


How many databases instances are there in sql server 2000?

539


Difference between DELETE and TRUNCATE?

593


What is the difference between for xml raw and for xml auto?

537


How to verify the port number of the sql server?

527






How you can get a list of all the table constraints in a database? : Sql server administration

492


Explain what are the events recorded in a transaction log?

525


What is indexing and its types?

497


What is an index in sql?

521


What is sql stored procedure?

571


please differentiate between delete and truncate?

530


What is a constant or literal in ms sql server?

562


Explain what is meant by replication of database?

507


How many types of attribute relationships are there? : sql server analysis services, ssas

557


Explain iaas, paas and saas?

70