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 database replicaion? What are the different types of replication you can set up in SQL Server?

Aptech, HCL, Perpetual, SAIC,

5 25512

How to determine the service pack currently installed on SQL Server?

HCL,

4 10482

Can you have a nested transaction?

HCL,

4 11909

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

HCL,

3 12513

What is the system function to get the current user's user id?

HCL,

2 13220

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 insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

HCL,

1 5265

What is the datatype returned by count(*)

247Customer, Asian CERC,

22 38900

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

2076

Can I remove the default constraint columns in SQL SERVER?

Value Labs,

5 15279

What is the difference between distinct clause and group by clause?

HHH, Value Labs,

2 16699

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

C3I, eSoft, iPRO Solutions, Wipro,

3 19521

What is an extended Stored Procedure?

1 6523

What is Trigger?

Misys,

3 10710

What is a view? is View updatable?

IBM, L&T,

17 34920

What is the difference between having and where clause?

4 10521

Un-Answered Questions { SQL Server }

What are the types of joins in sql?

1114

What is the correct order of the logical query processing phases?

928

Why normalization is used?

1004

Does partitioning ssd reduce performance?

888

How many instances per computer are there in sql server 2000?

1058

What are subqueries in sql server? Explain its properties.

1012

How do you drop an index?

916

What do you know about system database? : SQL Server Architecture

978

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

997

What is user-defined inline table-valued function?

939

What are the types of indexing?

1075

What is difference between materialized view and view?

905

Is the log file is a part of file group?

1028

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

901

Can foreign key be duplicate?

1052

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