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

Explain few of the new features of sql server 2008 management studio

923

What are “lost updates”?

1006

What command do we use to rename a db, a table and a column?

928

What is the difference between a function and a trigger?

1087

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

1090

What is a filestream?

996

What is difference between commit and rollback when used in transactions?

966

Data table as parameter in sql server?

1051

What is the xml datatype?

1086

What is the difference between index seek vs. Index scan?

1025

What is set nocount on and what is set nocount off?

937

Explain intellisense for query editing

1034

Explain primary key and foreign key constraints?

1039

Explain following error properties?

1023

Explain system scalar functions?

1004

Un-Answered Questions { SQL Server }

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

994

What is explicit mode in sql server?

1068

Can you roll back the ddl statement in a trigger?

982

Do you know what is blocking?

967

What is the difference between Triggers and Stored Procedure?

1101

What is #temp and @table variable in SQL server?

1096

Tell me the phases a transaction has to undergo?

965

How do I perform an unattended install of sql server 2000?

1086

explain different types of joins? : Sql server database administration

990

How many joins in sql server?

965

What is Command line parameters in PLSQL.?

1133

What is an identity column in insert statements?

1026

Can a rule be bound to any column of any data type?

965

what is the main function of a query parameter?

152

Why I am getting this error when dropping a database in ms sql server?

1079

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