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?

1048

What are subqueries in sql server? Explain its properties.

978

What do you understand by mirroring?

957

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

973

How can you check the version of sql server?

1058

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

896

What do you understand by physical_only option in dbcc checkdb?

951

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

1037

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

923

What do you understand by integration services in sql server?

931

What is single-user mode?

876

What are the differences between ms sql server & oracle?

1017

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

942

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

903

What is the command dbcc checkdb used for?

971

Un-Answered Questions { SQL Server }

What is a coalesce function?

1138

What is key attribute?

880

How to restore performance issues and how to check?

1954

How to make a column nullable?

1056

tell me the disaster recovery plan

2467

Explain error handling in ssis?

979

What is an example of a primary key?

925

What are the steps to insert a table?

900

Which command is used for user defined error messages?

1024

What is database black box testing?

993

How does clustered and non clustered index work?

856

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1102

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

876

Does server sql treat char as a variable-length or fixed-length column?

961

Why use “in” clause in sql server?

1005

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