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

1023

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

990

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

1132

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

1033

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

1131

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

998

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

1146

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

980

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

1128

How can sql injection be stopped? : sql server security

1033

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

1064

What are the database roles? : sql server security

1188

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

1014

How to recover from sql injection? : sql server security

1017

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

1113

Un-Answered Questions { SQL Server }

What is use of @@ spid in sql server?

1213

What is the cartesian product of table?

1009

How to view existing indexes on an given table using sp_help?

1137

What is the difference between for auto and for nested?

1001

What is onf in normalization form?

1056

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2521

What are the security related catalog views? : sql server security

949

What is merge statement?

1080

Explain the difference between cross join and full outer join?

980

What is pessimistic concurrency?

974

How to use the inserted and deleted pseudo tables?

961

What is the sql profiler?

940

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

What is snapshot parameter in ssrs?

150

How can I tell if sql server is 32 or 64 bit?

960

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