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,

1144

What does Master database contains?

Abacus,

1178

What gets stored inside msdb database?

Abacus,

1305

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

Abacus,

1113

Why Master database is required?

Abacus,

1182

Why SQL Agent is used?

Abacus,

1200

Explain the types of indexes.

Accenture,

1286

How network traffic be reduced by using the stored procedure?

Accenture,

1165

What is a trigger? Why we need it?

Accenture,

1048

What is the difference between functions and stored procedures?

Accenture,

1218

How self join is different from outer join?

Blue Star,

1170

What are the different types of indexes?

Blue Star,

1156

What is meant by referential integrity?

Blue Star,

1046

What new changes are being made in SQL Server?

Blue Star,

1256

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

Alcatel-Lucent,

1149

Un-Answered Questions { SQL Server }

what is sql server? : Sql server database administration

1035

What is lookup override?

1079

What is pivot and unpivot?

1060

How to return the top 5 rows from a select query in ms sql server?

1204

What are the basic functions for master, msdb, model, tempdb and resource databases?

1031

Explain following error properties?

1056

How you can get a list of all the table constraints in a database? : Sql server administration

1087

What is normalization according to you and explain its different levels?

993

Do you know the isolation level that sql server support?

999

Define inner join in sql server joins?

1121

what is isolation level at dead lock?

2205

How to Sync Two SQL Azure Databases?

121

Explain what is the function of sql server agent windows service?

1036

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

980

Can you please explain the difference between function and stored procedure?

1039

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