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 sql azure firewall rules?

106

What do you mean by data manipulation language?

1015

Explain sql server authentication modes?

1127

List out some of the requirements to set up a sql server failover cluster?

1034

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1105

Explain “row_number()” in sql server with an example?

1002

List out the different types of locks available in sql server?

977

What is a view in sql?

976

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1217

What are the different types of subquery?

1158

Can sql servers link to other servers like oracle?

842

Why we use the openxml clause?

1011

Can one drop a column from a table?

1020

What are the main differences between #temp tables and @table variables and which one is preferred?

1083

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

940

Un-Answered Questions { SQL Server }

How to execute a stored procedure in ms sql server?

1175

Do you know what is a linked server in sql server?

1024

What is partitioned view?

899

Can you explain different types of locks in sql server?

947

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

1021

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

941

Where is my database stored on the hard disk in ms sql server?

1058

What stored by the msdb? : sql server database administration

1003

How much space does sql server 2016 take?

974

How you can get a list of all the table constraints in a database? : Sql server administration

1027

How do I schedule a sql server profiler trace?

977

Can an entity have two primary keys?

980

Write a program using SQL queries to find a unique entry in a table.

993

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1018

what is dbcc? : Sql server database administration

1031

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