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 can you ensure that the database and sql server based application perform well?

1027

What do you understand by the data quality services in sql server?

915

What is the usage of the sign function?

1026

What are trace flags?

970

What are the steps you should follow to start sql server in single-user mode?

859

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

940

What do you understand by sql server agent?

922

What is transaction server isolation?

980

What is transaction server auto commit?

1003

What is transaction server explicit transaction?

979

What is transaction server distributed transaction?

991

What is transaction server consistency?

985

Do you know nested transaction?

915

Explain atomicity?

986

What is transaction server implicit?

952

Un-Answered Questions { SQL Server }

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1135

What is SubQuery in SQL Server 2008

975

List some advantages and disadvantages of stored procedure?

978

What is default constraint in ms sql server?

977

How we create SQL Server 2005 Reporting Services ? Give me Sample

1945

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

973

What is the difference between indexing and hashing?

1099

What is sleeping status in sql server?

993

What are recommended options to be used while using db mirroring? : sql server database administration

1089

Write an sql query to find first weekday of the month?

878

How do I open a .db file?

985

Comment,Datatypes are unlimited

2033

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

861

What are the types of table?

928

What is transact-sql ddl trigger?

1060

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