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,

1087

What does Master database contains?

Abacus,

1136

What gets stored inside msdb database?

Abacus,

1247

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

Abacus,

1072

Why Master database is required?

Abacus,

1141

Why SQL Agent is used?

Abacus,

1146

Explain the types of indexes.

Accenture,

1216

How network traffic be reduced by using the stored procedure?

Accenture,

1118

What is a trigger? Why we need it?

Accenture,

996

What is the difference between functions and stored procedures?

Accenture,

1161

How self join is different from outer join?

Blue Star,

1120

What are the different types of indexes?

Blue Star,

1118

What is meant by referential integrity?

Blue Star,

1010

What new changes are being made in SQL Server?

Blue Star,

1185

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

Alcatel-Lucent,

1116

Un-Answered Questions { SQL Server }

tell me the disaster recovery plan

2516

Do you know what are acid properties?

1078

What is resource governor in sql server?

995

Explain database normalization?

1220

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

908

What do you mean by a dependent functionality in a build?

1154

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

937

How do I find the size of a sql server database?

928

What is difference between getdate and sysdatetime in sql server 2008?

1047

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

Can you please explain the difference between primary keys and foreign keys?

1110

How can change procedure in sql server?

1062

Define inner join in sql server joins?

1058

How do you run a trace?

901

Do you know what are pages and extents? : SQL Server Architecture

995

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