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 isolation levels?

1023

What are the default system databases in sql server 2000?

1024

What does the not null constraint do?

1077

How to rebuild master databse?

1075

What command would you use to create an index?

1052

What command do we use to rename a database?

1072

Do comments need to go in a special place in sql server 2005?

852

What is the purpose of the model database?

1012

What is the sql server 2000 version number?

1074

Name 3 ways to get an accurate count of the number of records in a table?

1033

What is the difference between a local and a global temporary table?

1107

What is difference between delete & truncate commands?

1074

What stored by the msdb?

995

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1062

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

1141

Un-Answered Questions { SQL Server }

What is extent? Types of extents?

1179

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

909

Can we insert data into view sql server?

924

How to transfer an existing table from one schema to another schema in ms sql server?

979

what is the different types of backups available in sql server? : Sql server database administration

921

What is coalesce and check constraint in sql server?

1114

how many bits ip address consist of? : Sql server database administration

897

What does nvl stand for?

939

What is parameterized reports in ssrs ?

149

What is user-defined multi-statement table-valued function?

1053

What is use of except clause?

1092

What is the Difference Between Primary and Foreign Key?

1003

Explain contrast amongst grouped and non-bunched records?

1013

How to list all dsn entries on your local machine using odbc_data_source()?

1034

How to backup SQL Server Reporting Services ?

148

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