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 is the difference between coalesce() & isnull()?

1132

What is the difference between local and global temporary tables?

1138

What is bcp? When does it use?

943

What is the osql utility?

966

Explain the steps needed to create a scheduled job?

930

What are the types of joins in sql?

1126

What are orphan records?

932

What have included columns when we talk about sql server indexing?

1037

List all the types of user-defined functions?

1099

Why use “nolock” in sql server?

1058

Explain primary key in sql server?

1016

What is the filtered index?

1056

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

910

How will you go about resolving deadlocks?

970

What is the difference between osql and query analyzer?

994

Un-Answered Questions { SQL Server }

What is primary key index?

979

Distinguish between commit and rollback?

959

what are isolation levels? : Sql server database administration

991

how would you store your query in an SSRS report or a Database server?

162

How to make a remote connection in a database?

977

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

What do you mean by a Composite primary key?

1103

What are triggers in ms sql server?

1160

Explain what is “asynchronous” communication in sql server service broker?

917

Can you explain what is the use of custom fields in report?

1061

What is sql server used for?

1048

How do you debug a procedure in sql server?

943

What happens if time-only values are provided as date and time literals?

1017

What is difference between joins and subqueries?

1120

Do you know data definition language, data control language and data manipulation language?

1040

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