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 awe?

1007

When columns are added to existing tables, what do they initially contain?

1027

What is the order by used for?

1017

What is a transactions?

1035

What is row_number()?

982

What stored by the master?

947

What is 'write-ahead log' in sql server 2000 ?

1045

What is bcp? When does it used?

976

Which are new data types introduced in sql server 2008?

1042

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1137

What are the basic functions for master, msdb, model, tempdb and resource databases?

984

What is the purpose of the master database?

1116

Does server sql treat char as a variable-length or fixed-length column?

1013

Does sql server 2000 full-text search support clustering?

859

What is filtered index?

1089

Un-Answered Questions { SQL Server }

What is checkpoint process in the sql server?

1025

Data table as parameter in sql server?

1041

Why truncate is ddl?

1082

What happens if the update subquery returns no rows in ms sql server?

1120

What do you mean by normalisation?

1034

What is the cartesian product of table?

1004

What is a user-defined function in the sql server and what is its advantage?

1096

Describe the functionalities that views support.

1096

what is the information that can be stored inside a bit column? : Sql server database administration

958

How to disable a login name in ms sql server?

1129

What action plan is preferred if sql server is not responding?

1098

Does index speed up select statements?

1010

How do I edit a stored procedure in sql server?

920

Explain what are page splits? : SQL Server Architecture

1057

What is user-defined inline table-valued function?

942

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