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

Explain about system stored procedure?

1083

Explain syntax for viewing trigger?

972

How to create a store procedure with encryption?

1059

Explain the difference between primary keys and foreign keys?

1107

What is ms sql server index?

1155

What are clustered and non-clustered index?

1055

Explain the categories of stored procedure?

988

Define full outer join in sql server joins?

1059

What are the events recorded in a transaction log?

1050

What are the disadvantages of indexes?

1166

Explain datetime2 data type in sal server 2008?

954

Explain about system database?

1110

How use inner join in sql server?

1192

Why we need sql server?

1015

Can we call stored procedure in view in sql server?

942

Un-Answered Questions { SQL Server }

What are the types of resultset?

1018

A trigger can reference objects outside the current database? State true or false.

1062

can an order by clause be used in a creation of a view?

1243

Does transparent data encryption provide encryption when transmitting data across the network?

1101

What command would you use to create an index?

1114

What are the advantages to use stored procedures?

1184

Define msdb database?

1079

Tell me what is use of except clause? How it differs from not in clause?

1003

What is difference between index seek vs. Index scan?

1203

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1112

Can we update data in a view?

1082

Difference between 2NF &3NF ?

1133

How do you set a trace flag in sql server?

1098

What is a document index?

1076

What are the types of subscriptions in SQL Server replication?

1112

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