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,

1028

What does Master database contains?

Abacus,

1083

What gets stored inside msdb database?

Abacus,

1195

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

Abacus,

1001

Why Master database is required?

Abacus,

1058

Why SQL Agent is used?

Abacus,

1065

Explain the types of indexes.

Accenture,

1112

How network traffic be reduced by using the stored procedure?

Accenture,

1044

What is a trigger? Why we need it?

Accenture,

941

What is the difference between functions and stored procedures?

Accenture,

1091

How self join is different from outer join?

Blue Star,

1061

What are the different types of indexes?

Blue Star,

1046

What is meant by referential integrity?

Blue Star,

957

What new changes are being made in SQL Server?

Blue Star,

1098

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

Alcatel-Lucent,

1047

Un-Answered Questions { SQL Server }

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3816

What are the built in functions in sql server?

917

What is the temp table?

866

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

952

Does partitioning improve performance?

917

What are out-of-range errors with date and time literals?

965

Define Wed Edition in SQL Azure?

100

List few advantages of stored procedure.

924

What is reportserver and reportservertempdb ?

142

What is the concept of optimization?

990

what are constraints? : Sql server database administration

982

What is the difference between set and select?

1015

what is a transaction and what are acid properties? : Sql server database administration

963

What are the properties of the relational tables?

829

What is transaction server consistency?

980

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