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

Explain use of expression builder.

1069

What is use of except clause? How does it differ from not in clause?

1064

What are cursors and when they are useful?

1149

What is raid and what are different types of raid levels?

1191

What do you understand by a view? What does the with check option clause for a view do?

1054

Define views.

1068

What is cte (common table expression)?

1085

What do you mean by an execution plan? Why is it used?

1075

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1092

Describe in brief system database.

1068

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1060

What is normalization of database? What are its benefits?

1070

What is difference between index seek vs. Index scan?

1199

Explain indexed views?

1027

What are the properties of the relational tables?

926

Un-Answered Questions { SQL Server }

Explain comment on transactions?

1041

Explain transaction server auto commit?

1087

What is public role in sql server?

1209

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2809

What is the function of sql server agent windows service?

1144

What is an active database?

1067

How to delete all rows with truncate table statement in ms sql server?

1045

What is scan table/view and seek table/view when its occurs? : sql server database administration

1088

What is index in an assignment?

994

How do you identify a foreign key?

1082

What do you understand by recursive stored procedures?

1043

Do you think BCNF is better than 2NF & 3NF? Why?

1338

Explain about SQL server 2005?

1026

How to create function with parameter in sql server?

1154

Explain the truncate command? : SQL Server Architecture

1230

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