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

Tell me about builtinadministrator?

990

Do you know what is xpath?

1080

What is public role in sql server?

1142

Explain full-text query in sql server?

995

Do you know how to make remote connection in database?

958

Tell me what are the advantages of using stored procedures?

1001

How to make remote connection in database?

1002

Explain what are the different index configurations a table can have?

1104

Tell me what is difference between view and materialized view?

932

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1003

Do you know concepts and capabilities of sql server?

1056

Explain how to use linked server?

988

What do you mean by an execution plan? How would you view it?

911

Do you know what are acid properties of transaction?

952

Explain what is lock escalation?

1059

Un-Answered Questions { SQL Server }

Define self join?

1023

How do you check sql server is up and running?

993

why would you call update statistics? : Sql server database administration

1080

Can you please explain the difference between primary keys and foreign keys?

1102

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

879

Which sql server is best?

990

Which are ddl commands?

1038

Explain primary key, foreign key and unique key?

987

What is triggers in ms sql server?

1113

Explain what is the purpose of sql profiler in sql server?

1066

Explain data warehousing in sql server?

1040

Explain following error properties?

1010

Explain aggregate functions?

1076

How can delete duplicate records in cte in sql server?

964

explain different levels of normalization? : Sql server database administration

1000

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