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 model database? : SQL Server Architecture

1189

What is raid? : SQL Server Architecture

1225

Explain what are page splits? : SQL Server Architecture

1119

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

1058

Please illustrate physical database architecture? : SQL Server Architecture

1025

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

967

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1123

What are logical database components? : SQL Server Architecture

1094

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1172

What is msdb database? : SQL Server Architecture

1198

What is master database? : SQL Server Architecture

1081

Explain what are the database objects? : SQL Server Architecture

1143

What are pages and extents? : SQL Server Architecture

1071

Do you know spatial data types - geometry and geography in sql server 2008?

1089

Un-Answered Questions { SQL Server }

Write query to return all rows sql?

1110

What is the purpose of optimization?

1058

What are built in functions?

1067

What is a with(nolock)?

1025

What are the types of sql server?

1096

How many ways to create table-valued functions?

1054

Can an entity have two primary keys?

1030

How to modify an existing stored procedure in ms sql server?

1137

What is an index. What are the types?

1161

What is subreport?

144

Where the sql logs gets stored? : sql server database administration

1014

What are the operating modes in which database mirroring runs?

1137

What are points to remember while using the fillfactor argument?

1018

Why the trigger fires multiple times in single login?

1280

Delete duplicate rows without using rowid.

1586

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