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

Can you explain what are commit and rollback in sql?

934

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

995

Do you know what are pages and extents? : SQL Server Architecture

991

Explain the truncate command? : SQL Server Architecture

1166

What are page splits? : SQL Server Architecture

985

What is tempdb database? : SQL Server Architecture

1186

What is database architecture? : SQL Server Architecture

1036

What are different types of raid configurations? : SQL Server Architecture

1069

What do you know about system database? : SQL Server Architecture

979

What are the database objects? : SQL Server Architecture

1041

What are the restrictions applicable while creating views? : SQL Server Architecture

1021

Explain the microsoft sql server delete command? : SQL Server Architecture

1075

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1046

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

997

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1000

Un-Answered Questions { SQL Server }

What are data regions?

135

You want to implement the one-to-one relationship while designing tables. How would you do it?

962

explain declarative management framework (dmf) in sql server 2008?

985

Please explain what is “asynchronous” communication in sql server service broker?

933

Will the writetext statement activate a trigger?

1088

When is the use of update_statistics command?

997

What are joins in sql and what are the different types of joins?

1009

Determine how to use the inserted and deleted pseudo tables?

985

How do I install sql server?

884

State the difference between union and union all?

926

How to find the second highest salary of an employee?

1172

How to return the top 5 rows from a select query in ms sql server?

1130

Explain few examples of RDBMS?

1036

What is the difference between getdate and sysdatetime?

999

Explain what are the database objects? : SQL Server Architecture

1073

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