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

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

Aviva,

1 3617

how to generate XML out of QUERY?

McAfee,

1 5190

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

Infosys, McAfee,

5 10934

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

Intelenet,

8 32848

hi i gone though satyam interview. what is Acid Properties?

Satyam,

2 5966

what are batch in sql server?

Satyam,

2 10057

Difference Between varchar and nvarchar datatype?

Satyam,

3 14236

Difference between sql server 2000 and sql server 2005?

Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

11 53147

what is normalization? what is denormalization?

Satyam,

9 35079

what is extended StoreProcedure ?

Satyam,

3 6827

Different Types of Functions ?

Satyam,

2 12743

CLR Integration ? what is Notification services ?

HCL, Satyam,

1 5317

what is replication? where do u use Go Keyword?

Satyam,

1 4914

how do u do Performance tunning ?

Infodat Technologies, Satyam,

1 5078

How to find the date and time of last updated table?

3 9324

Un-Answered Questions { SQL Server }

What happens if strings are casted into wrong code pages in ms sql server?

1113

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1048

What is normalization and its types?

1032

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1847

Explain the third normal form(3nf)?

943

Explain system views?

1086

What are indexes in sql?

1281

Explain candidate key, alternate key, and composite key?

1003

What are different types of table joins?

1004

What is the difference between system objects and user objects?

1159

What are the authentication modes in sql server? How can it be changed?

1128

What are the advantages dts has over bcp?

1000

What are the steps you will take to improve the performance of a poor performing query?

979

What is the maximum length of an alert name?

1001

Differentiate sql server reporting services vs. Crystal reports?

200

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