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

How do you set a trace flag in sql server?

1036

How do I schedule a sql server profiler trace?

977

What happens if we shrink log file in sql server?

983

How do I create an extended event in sql server?

952

What is trace flag in sql server?

1023

What are extended events in sql server?

955

What is resource governor in sql server?

995

Is foreign key unique?

995

Is foreign key a primary key?

1091

What are rows and columns?

1019

What are the steps to insert a table?

945

Can primary key be null?

932

What are some examples of schemas?

980

How many types of schemas are there?

1042

How do you identify a foreign key?

1024

Un-Answered Questions { SQL Server }

What are the requirements to use odbc connections in php scripts?

1120

What is system stored procedures?

1040

What is an indexing technique?

936

What are the different types of subquery?

1158

what are acid properties? : Sql server database administration

997

explain declarative management framework (dmf) in sql server 2008?

993

what is memory-optimized nonclustered indexes

1016

What is Transparent Data Encryption?

1001

Can group functions be mixed with non-group selection fields in ms sql server?

942

What happens if you insert a duplicate key for the primary key column in ms sql server?

976

Can we do dml on views?

956

How do I manually uninstall an instance of sql server 2016?

1038

Which are ddl commands?

1047

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

Explain the disadvantages/limitation of the cursor?

963

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