SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

what is web server?

Satyam,

3 10580

What are functions

3 8122

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

4 33230

What command do we use to rename a db?

IBM,

5 10292

What are the four main query statements?

Wipro,

7 18045

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

3 13603

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

2 18568

What is SQL server agent?

HCL, SAP Labs,

2 7395

What is the purpose of UPDATE STATISTICS?

2 11281

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

3 6649

Difference between Function and Stored Procedure?

C1 India, NA,

9 17289

What is data integrity? Explain constraints?

Thinksoft,

1 24064

Explain some DBCC commands?

6 16538

What are tasks?

Wipro,

3 9968

What is the purpose of using COLLATE in a query?

1 17327

Un-Answered Questions { SQL Server }

How display code or Text of Stored Procedure using Sql query in Sql Server ?

368

How to update muliple row in single query?

338

What are key, name and value columns of an attribute? : sql server analysis services, ssas

339

How is foreign key related to primary key?

305

What method is used by the Command classes to execute SQL statements that return single values?

367

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

Define outer join in sql server joins?

323

Define left outer join?

324

Explain an automatic checkpoint

356

What is the full form of ddl?

291

What are the dmvs? : sql server database administration

369

How to find index size for each index on table?

372

What are the purposes and advantages stored procedure?

302

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

382

what are the different types of replication you can set up in sql server? : Sql server database administration

293

For More Un-Answered { SQL Server } Questions Click Here