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

1124

What is raid? : SQL Server Architecture

1170

Explain what are page splits? : SQL Server Architecture

1057

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

996

Please illustrate physical database architecture? : SQL Server Architecture

982

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

913

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

1061

What are logical database components? : SQL Server Architecture

1031

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

972

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

1118

What is msdb database? : SQL Server Architecture

1127

What is master database? : SQL Server Architecture

1017

Explain what are the database objects? : SQL Server Architecture

1073

What are pages and extents? : SQL Server Architecture

1015

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

1029

Un-Answered Questions { SQL Server }

How to update values in a table with update statements in ms sql server?

1013

Explain Geography datatype in SQL Server

1127

What is the difference between primary key and unique constraints?

953

What is nonclustered index on computed columns?

952

How do I view views in sql server?

1003

What is merge replication?

1103

What are different types of subquery?

1239

Explain what is meant by replication of database?

1027

What is the new security features added in sql server 2014? : sql server security

996

What is the purpose of self join?

971

explain different levels of normalization? : Sql server database administration

1001

Differentiate between SQL and ORACLE joins and write their syntax.

1031

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1186

How many types of database relationship in sql server?

1052

How to execute stored procedure in select statement sql server?

1054

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