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 update locks?

887

Determine when an index is appropriate?

1076

Can you explain important index characteristics?

991

Explain the purpose of indexes?

976

Explain full-text indexing?

982

Do you know clustered and non-clustered index?

979

Explain the difference between clustered and non-clustered index?

923

Explain having clause and where clause?

1055

Explain indexes disadvantages?

1084

Explain what is it unwise to create wide clustered index keys?

977

Ms sql server index?

1062

Do you know what is fill factor and pad index?

1004

How to maintain a fill factor in existing indexes?

1006

Write down the syntax and an example for create, rename and delete index?

984

Tell me the difference between clustered and non-clustered index?

937

Un-Answered Questions { SQL Server }

How to override dml statements with triggers?

1183

What is best institute to Learn DotNET And SQL in chennai?

2161

How use inner join in sql server?

1133

How do indexes help, types?

959

Do you know the cursor types?

1156

Mention the different types of triggers?

1116

Are resultset updatable?

953

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

936

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

How column data types are determined in a view?

961

Explain iaas, paas and saas?

How can we use ConnectorJ JDBC Driver with MS SQL?

999

how you can configure a running aggregate in SSRS?

190

What is 1nf 2nf and 3nf?

891

What specific conditions database should meet, before you can bulk copy data into it using bcp?

986

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