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

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 22690

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 4044

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

Deloitte, Lason,

9 29206

A left outer join B B right outer join A gives the same result then what is the use of two?

1 5430

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8642

event classes in sql server

Accenture, AFE,

2 7913

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11484

what is macro?

Excel, Global Innovation, Wipro,

5 12967

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

2144

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 5714

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 12056

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 9365

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 6302

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 16952

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 10863

Un-Answered Questions { SQL Server }

When do you think a developer should use sql server-based cursors?

1105

What is optimization and its types?

1039

What is difference between joins and subqueries?

1172

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

What is meant by dirty read?

1041

How do I save a stored procedure in sql server?

1052

what are database files and filegroups? : Sql server database administration

999

To which devices can a backup be created and where should these devices be located? : sql server management studio

1102

What do you understand by physical_only option in dbcc checkdb?

1024

What are truncate options available in sql server? : sql server database administration

1084

What are user defined functions in ms sql server?

1064

Why is the need for data conversion transformations?

1113

List out the differences between global and local temp tables in sql server?

1112

What is unique key constraint?

1118

Difference between Inner vs outer joins?

988

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