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

1194

What is raid? : SQL Server Architecture

1232

Explain what are page splits? : SQL Server Architecture

1122

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

1062

Please illustrate physical database architecture? : SQL Server Architecture

1034

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

968

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

1129

What are logical database components? : SQL Server Architecture

1101

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

1178

What is msdb database? : SQL Server Architecture

1204

What is master database? : SQL Server Architecture

1086

Explain what are the database objects? : SQL Server Architecture

1151

What are pages and extents? : SQL Server Architecture

1077

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

1094

Un-Answered Questions { SQL Server }

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

1000

What is the concept of optimization?

1112

How to attach adventureworkslt physical files to the server?

1166

Explain transaction server auto commit?

1092

Can we hide the definition of a stored procedure from a use?

1301

How do we Backup SQL Azure Data?

108

What is table constraint?

1054

How to set database to be single_user in ms sql server?

1084

What is dirty read?

1139

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1031

What are the instances when triggers are appropriate?

1022

What are the advantages of passing name-value pairs as parameters?

1224

what is raid and what are different types of raid configurations? : Sql server database administration

1107

Mention what are the different types of ssrs reports?

158

Explain indexes disadvantages?

1151

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