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

1086

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

1134

Differentiate between a having clause and a where clause.

1010

Explain the stored procedure?

1100

What functions can a view be used to performed?

1120

Describe the functionalities that views support.

1152

Explain primary key?

1007

What are partitioned views and distributed partitioned views?

1067

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

1098

Explain the concept of recursive stored procedure.

1028

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

987

What is dbcc? Give few examples.

1086

What is row_number function?

1058

What do you mean by an execution plan?

1193

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

1160

Un-Answered Questions { SQL Server }

What are the five major components of a dbms?

965

What are the various editions of sql server 2017 that are available in the market?

944

Explain tables in SQL Azure?

122

where the connection string store in the database

2124

What is report subscription?

132

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1061

What is raid, and how it can influence database performance?

1102

Can you always create a cache of a report?

178

Explain what role entity and relationship play in an ER diagram.

1115

What is the difference between NOROW and LOCKROW?

2906

How to use user defined functions in expressions?

1157

How to execute a sql statement using mssql_query()?

1110

What are sub reports?

208

What is stored procedures?

1112

What is explicit mode in sql server?

1113

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