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 trace flags and mention a few common trace flags used with sql server?

1087

What are subqueries in sql server? Explain its properties.

1019

What do you understand by mirroring?

997

What are joins in sql and what are the different types of joins?

1014

How can you check the version of sql server?

1095

Write a query to find 5th highest amount paid from the customer table.

934

What do you understand by physical_only option in dbcc checkdb?

979

What are the differences between substr and charindex in sql server.

1115

What are relationships and mention different types of relationships in the dbms

962

What do you understand by integration services in sql server?

962

What is single-user mode?

940

What are the differences between ms sql server & oracle?

1061

What part does database design plays a role in performance of an sql server-based application?

982

What do you understand by replication in sql server? Mention the different types of replication in sql server.

943

What is the command dbcc checkdb used for?

1010

Un-Answered Questions { SQL Server }

What is normalization 1nf 2nf 3nf?

1060

How to write a query with a full outer join in ms sql server?

1077

Difference between primary key and clustered index?

1005

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

Where actually sql azure database is hosted?

163

Explain the difference between control flow and data flow?

994

What are scalar functions?

1000

Is t sql the same as sql server?

974

What method is used by the Command classes to execute SQL statements that return single values?

1068

What are the different types of replication you can set up in sql server?

1052

Explain tablesample?

999

How can change procedure in sql server?

1063

You want to implement the many-to-many relationship while designing tables. How would you do it?

997

What is difference between aggregate and analytic function?

936

How do I perform an unattended install of sql server 2000?

1086

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