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 the difference between OLEDB and ODBC

CFCI,

4 12887

What are mdf,ndf,ldf files and how to see the data in those files?

Accenture,

6 60464

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

Value Labs,

2557

What is the difference between DTS and SSIS?

Allianz,

3 37704

How to Debug a Stored Procedure?

Allianz,

5 14452

How to link up the text file to a Database table?

Allianz,

2 6547

Which institute is best for SQL Server 2005 Training?

6 7596

What is user stored procedure & it purpose?

Wipro,

4 8570

How do we rollback the table data in SQL Server

3 17154

where do you use Isolations?give me some exmpale?

1 5334

In which year relase the 7.0& 2000 & 2005?

1 3853

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

Covansys,

1 6272

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 7920

select empid empname from employee What is the result for the about query?

4 7885

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 6395

Un-Answered Questions { SQL Server }

What is clr ddl trigger?

1036

how can you attach more than 20 ldf files in sql server

2052

If no size is defined while creating the database, what size will the database have?

1036

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2256

Explain features and concepts of analysis services?

1024

What is the difference between mysql and sql server?

1094

Why I have to use stored procedures?

1097

What is the library index called?

1115

What program is used to store the data source file?

1010

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

995

What authentication modes does sql server support?

1155

You want to implement the one-to-one relationship while designing tables. How would you do it?

1019

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1048

What is 3nf normalization?

1051

What is difference between group by and having?

996

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