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 are the new security features added in sql server 2012? : sql server security

1015

Name three of the features managed by the surface area configuration tool? : sql server security

986

What is sql injection and why is it a problem? : sql server security

1124

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1029

What are the extra roles available in msdb? : sql server security

1125

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

992

How can sql server instances be hidden? : sql server security

1136

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

972

What are the fixed server level roles? : sql server security

1119

How can sql injection be stopped? : sql server security

1027

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1060

What are the database roles? : sql server security

1167

How to resolve the orphan use problem? : sql server security

1012

How to recover from sql injection? : sql server security

1006

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

1099

Un-Answered Questions { SQL Server }

What is a fan-out query in SQL Azure?

121

How many tables can be joined in SQL Server?

1054

What are the differences between sql server and mysql.

1084

What is coalesce and check constraint in sql server?

1110

How to disable stored procedure sql server?

1598

What is data source object?

996

What is stored in the mssqlsystemresource database? : sql server database administration

1024

what is a mixed extent? : Sql server administration

1095

Why do you need a sql server?

1097

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

968

What is table valued function and scalar valued functions?

1075

What area unit the various kinds of info compression introduced in sql server 2008?

1071

Explain cursor as data base object?

1033

What are types of scd? : sql server analysis services, ssas

1009

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1180

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