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

Explain left outer join and right outer join?

1032

What is the bookmark lookup and rid lookup?

996

What is local temp table?

947

What is difference between getdate and sysdatetime in sql server 2008?

1047

Explain insert into select statement?

951

What are policy management terms?

981

What is data compression?

988

How to copy the tables, schema and views from one sql server to another?

1045

what is unique and xaml nonclustered index

1042

Is it possible to create trigger on views?

970

What is user-defined inline table-valued function?

942

Difference between uniqe index and uniqe constraint?

973

What are ddl triggers and types of ddl trigger?

1037

How many non clustered indexes there can be on table ?

915

What are different types of subquery?

1236

Un-Answered Questions { SQL Server }

When you use @@error and try-catch?

1039

what is the maximum size of a row? : Sql server database administration

1007

How to test odbc dsn connection settings?

1026

What happens if you delete a table that is used by a view?

980

What are the different types of indexes?

1110

What is key set driven?

950

Explain what role entity and relationship play in an ER diagram.

1069

What is difference between materialized view and view?

907

What is scan table/view and seek table/view when its occurs? : sql server database administration

1038

What is the difference between truncate and delete commands?

1062

what authentication modes does sql server support? : Sql server database administration

1096

How to list all columns in a table using odbc_columns()?

972

What are the types of indexing?

1077

What is service broker? : sql server database administration

990

What are the Advantages of using CTE in sql server?

1113

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