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?

1010

How do I schedule a sql server profiler trace?

940

What happens if we shrink log file in sql server?

930

How do I create an extended event in sql server?

921

What is trace flag in sql server?

994

What are extended events in sql server?

921

What is resource governor in sql server?

960

Is foreign key unique?

966

Is foreign key a primary key?

1009

What are rows and columns?

971

What are the steps to insert a table?

907

Can primary key be null?

895

What are some examples of schemas?

936

How many types of schemas are there?

1000

How do you identify a foreign key?

990

Un-Answered Questions { SQL Server }

What is 4nf in normalization form?

978

What is the report builder?

135

What is BCNF? How is it better than 2NF & 3NF?

983

How do I find the size of a sql server database?

894

Explain different backup plans?

898

How to connect php with different port numbers?

1029

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1923

What is sql profiler. What are the default templates with it? : sql server database administration

980

What are the differences between web role and worker role?

122

What is the fastest way to permanently delete a 1 million row table named customers?

1204

What is a transaction and why is it important?

1032

what is normalization? : Sql server database administration

1043

what are user defined datatypes and when you should go for them? : Sql server database administration

978

What do you mean by SQL injection attack?

1027

What is buffer cash in sql server?

1117

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