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

1133

What is raid? : SQL Server Architecture

1179

Explain what are page splits? : SQL Server Architecture

1065

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

1001

Please illustrate physical database architecture? : SQL Server Architecture

988

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

917

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

1066

What are logical database components? : SQL Server Architecture

1037

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

978

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

1125

What is msdb database? : SQL Server Architecture

1134

What is master database? : SQL Server Architecture

1021

Explain what are the database objects? : SQL Server Architecture

1083

What are pages and extents? : SQL Server Architecture

1017

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

1033

Un-Answered Questions { SQL Server }

What is the difference between varchar and nvarchar?

941

what do you understand by change data capture?

1024

What Is Rdbms?

1158

can a table be moved to different filegroup? : Sql server administration

978

What is the language structure to add a record to a table?

1025

Give me any three differences between Truncate and Delete.

1107

How and why use sql server?

1009

What is the recommended total size of your memory optimized tables?

966

Explain boyce and codd normal form(bcnf)?

958

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What are the system database in sql server 2008?

1035

What is unique key constraint?

1061

How do you start single user mode in clustered installations?

941

How to use go command in "sqlcmd"?

1207

Tell me what is a linked server?

1040

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