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.

954

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

930

What is dbcc? Give few examples.

1033

What is row_number function?

1006

What do you mean by an execution plan?

1116

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

1100

Un-Answered Questions { SQL Server }

How would we use distinct statement? What is its use?

1072

Explain about remote stored procedure?

1008

What are key constraints?

974

How much space does sql server 2016 take?

974

Describe in brief authentication modes in sql server.

1027

What does nvl stand for?

943

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

1033

What is the difference between the 2 operating modes of database mirroring?

1111

What are the 7 disadvantages to a manual system?

983

What are the steps to follow to configure SQL*Net?

1039

how we use window authentication connection with sql server.?

1152

What is spatial and temporal data?

1004

Mention a few common trace flags used with sql server?

929

Can sub report data source be different from that of the parent report?

143

Explain full-text query in sql server?

1005

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