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

Explain use of expression builder.

1015

What is use of except clause? How does it differ from not in clause?

1020

What are cursors and when they are useful?

1089

What is raid and what are different types of raid levels?

1150

What do you understand by a view? What does the with check option clause for a view do?

1003

Define views.

1012

What is cte (common table expression)?

1032

What do you mean by an execution plan? Why is it used?

1024

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1004

Describe in brief system database.

1011

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1001

What is normalization of database? What are its benefits?

1026

What is difference between index seek vs. Index scan?

1155

Explain indexed views?

981

What are the properties of the relational tables?

881

Un-Answered Questions { SQL Server }

Explain the steps to create and execute a user-defined function in the sql server?

967

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

What is database architecture? : SQL Server Architecture

1044

What is the difference between Clustered and Non-Clustered Index?

1059

How to create a user name in a database?

1054

What are the options which must be set to allow the usage of optimistic models?

963

Explain what is raid and what are different types of raid levels?

1025

How to download and install microsoft .net framework version 2.0?

1139

What is normalization according to you and explain its different levels?

949

Explain boyce and codd normal form(bcnf)?

958

Write an sql query to find first weekday of the month?

917

what is database replicaion? : Sql server database administration

1193

What are the aggregate and scalar functions?

1068

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

963

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

929

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