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 objects does the fn_my_permissions function reports on? : sql server security

1034

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1091

Differentiate between a having clause and a where clause.

965

Explain the stored procedure?

1053

What functions can a view be used to performed?

1060

Describe the functionalities that views support.

1099

Explain primary key?

965

What are partitioned views and distributed partitioned views?

1022

What are the basic functions for master, msdb, model, tempdb databases?

1041

Explain the concept of recursive stored procedure.

958

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

930

What is dbcc? Give few examples.

1036

What is row_number function?

1007

What do you mean by an execution plan?

1117

What is a trace frag? Where do we use it?

1100

Un-Answered Questions { SQL Server }

Explain an incremental backup?

1001

How to recover from sql injection? : sql server security

1017

What is b tree index?

915

what is a correlated sub-query? : Sql server database administration

941

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1055

Do you know hot add cpu in sql server 2008?

952

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

What does sql server mean?

1067

How to verify a user name with sqlcmd tool?

1080

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

1030

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

What is isnull() operator?

1037

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

Mention the different types of replication in sql server.

1026

What is nolock hint in sql server 2008

1127

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