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

What is identity?

1080

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

1030

What are synonyms?

1016

What is the default order of an order by clause?

1035

What are the authentication modes in sql server? How can it be changed?

1193

What is acid properties?

1190

Can we perform backup restore operation on tempdb?

1074

What is pivot and unpivot?

1066

What is dirty page?

1035

What is extent? Types of extents?

1276

What is the default value of an integer data type in sql server 2005?

994

What are the different editions available in sql server 2000?

1112

Can a synonym name of a table be used instead of a table name in a select statement?

1092

How do I determine how many instances of sql server are installed on a computer?

1057

What does the on update no action do?

1079

Un-Answered Questions { SQL Server }

what is a self join? : Sql server database administration

1122

What is the simplest way to create a new database in ms sql server?

1050

What is the difference between indexing and hashing?

1222

What is the New in SQL server 2008?

1017

What is the need for indexing?

988

What command must you use to include the not null constraint after a table has already been created?

1234

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1175

What is sql collation?

1271

How do I connect to sql server database?

1067

Can two different columns be merged into single column? Show practically?

1122

Write a program to fetch first 10 records from a file?

1063

What is an identity?

1076

What are the essential components of sql server service broker?

1065

What is the default server name for sql server?

1234

When would you prefer to have a minimum number of indexes?

961

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