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

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 10607

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2502

ow to bring suspect mode datbase online from scratch

1806

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2105

wat new abt truncate in sql server

HCL, HP,

2 6835

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1838

on line cluster can we make if yes tell me the procedure

Microsoft,

2023

which backup strategy you are following at ur company

2147

your distribution database is full what will u do

2172

Differences between logshipping and mirroring

Microsoft, Syntel,

1 5350

tell me the disaster recovery plan

Microsoft,

2516

application server is slow what may be the problem

Microsoft,

2223

Define the term DML, DDL and DTL?

1 31759

Creating Tables Using SELECT

1 3394

How can I create a table from another table without copying any values from the old table?

3 5726

Un-Answered Questions { SQL Server }

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1078

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1122

Explain optimistic and pessimistic concurrency?

993

What is table value parameters (tvp)?

1101

What is t-sql script to take database offline – take database online.

1087

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

What is the temp table?

923

What is normalization and what are the advantages of it?

985

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

What happens if null values are involved in datetime operations?

975

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1060

Do you know the different ddl commands in sql?

1054

Can I save my report as html, excel or word? : sql server management studio

955

Can you leave a union at any time?

1062

what authentication modes does sql server support? : Sql server database administration

1109

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