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 22243

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 3978

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 28937

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

1 5365

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 8546

event classes in sql server

Accenture, AFE,

2 7803

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 11318

what is macro?

Excel, Global Innovation, Wipro,

5 12805

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

Cognizant,

2092

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 5599

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

1 11981

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

Zenith,

1 9263

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

Apollo,

2 6182

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

2 16836

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

1 10791

Un-Answered Questions { SQL Server }

List some case manipulation functions in sql?

1027

What are data resources?

911

Tell me what is de-normalization and what are some of the examples of it?

1043

Do you know what are different types of replication in sql server?

1099

Explain what is sql server english query?

1051

What are the 3 types of schema?

1110

How to create prepared statements using odbc_prepare()?

1065

Mention the differences between having and where clause.

1057

How sql server enhances scalability of the database system?

1216

Working with TLogs

1832

How to delete duplicate rows from table except one?

989

What are the ways available in sql server to execute sql statements?

1135

How to update muliple row in single query?

1058

What are the five major components of a dbms?

929

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

958

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