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

How many databases Microsoft SQL server provides?

Abacus,

1034

What does Master database contains?

Abacus,

1087

What gets stored inside msdb database?

Abacus,

1205

What is the use of tempdb? What values does it hold?

Abacus,

1016

Why Master database is required?

Abacus,

1066

Why SQL Agent is used?

Abacus,

1076

Explain the types of indexes.

Accenture,

1128

How network traffic be reduced by using the stored procedure?

Accenture,

1058

What is a trigger? Why we need it?

Accenture,

949

What is the difference between functions and stored procedures?

Accenture,

1109

How self join is different from outer join?

Blue Star,

1073

What are the different types of indexes?

Blue Star,

1054

What is meant by referential integrity?

Blue Star,

964

What new changes are being made in SQL Server?

Blue Star,

1114

What are the disadvantages of primary key and foreign key in SQL?

Alcatel-Lucent,

1064

Un-Answered Questions { SQL Server }

Explain what is the use of custom fields in report?

881

How to get a list of columns in a view using the "sp_help" stored procedure?

994

What is replace and stuff function in sql server?

1008

What is t-sql script to take database offline – take database online.

1033

Explain the properties of the relational tables?

946

What is 2nf normalization form?

1066

How to retrieve error messages using mssql_get_last_message()?

1001

What is efficiency data?

917

Other than truncate statement, which other command can by-pass the trigger on the tables?

1083

What are the advantages of passing name-value pairs as parameters?

1126

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

857

What is difference between unique and primary key?

863

When we should use and scope of @@identity?

957

Tell me what is log shipping?

946

How to include text values in sql statements?

999

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