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()?

1056

What is the difference between local and global temporary tables?

1087

What is bcp? When does it use?

883

What is the osql utility?

920

Explain the steps needed to create a scheduled job?

886

What are the types of joins in sql?

1069

What are orphan records?

894

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

998

List all the types of user-defined functions?

1012

Why use “nolock” in sql server?

996

Explain primary key in sql server?

979

What is the filtered index?

990

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

864

How will you go about resolving deadlocks?

923

What is the difference between osql and query analyzer?

944

Un-Answered Questions { SQL Server }

Explain the difference between HTTP and HTTPS in database?

979

What is a heap?

993

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1017

How retrieve field names from the table in SQL through JAVA code?

1850

how you can configure a running aggregate in SSRS?

186

What is difference between aggregate and analytic function?

881

What is difference statement and preparedstatement?

939

What will happen if a column containing char type data is changed to the nchar data type?

1054

what is the difference between Delete and Truncate command in SQL

1094

How to handle error or exception in sql?

948

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1081

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

963

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

982

Define tool Manage Statistics in SQL Server 2000 query ?

1033

What is cached report?

139

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