SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between OLEDB and ODBC

CFCI,

4 10936

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

Accenture,

6 58002

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

Value Labs,

2057

What is the difference between DTS and SSIS?

Allianz,

3 35800

How to Debug a Stored Procedure?

Allianz,

5 11834

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

Allianz,

2 5172

Which institute is best for SQL Server 2005 Training?

6 5454

What is user stored procedure & it purpose?

Wipro,

4 6959

How do we rollback the table data in SQL Server

3 15686

where do you use Isolations?give me some exmpale?

1 4529

In which year relase the 7.0& 2000 & 2005?

1 3045

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 5387

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 6365

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

4 6044

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

Teledata,

2 5313


Un-Answered Questions { SQL Server }

How many types of functions are there in sql server?

440


Is BCNF better than 2NF & 3NF? Why?

598


What do you mean by sql server 2005 express management tools?

755


What is bcp? When does it use?

491


What does select 1 mean?

508






What is the difference between for xml raw and for xml auto?

543


What is sql server schema compare? How we can compare two database schemas?

528


What are the aggregate and scalar functions?

491


Can we write trigger for view?

536


When I run the sql server 2000 setup, it just hangs. What do I do?

626


What is the contrast between sql and pl/sql?

597


How will you monitor replication latency in transactional replication? : sql server replication

574


Define constraints and give an example of their use?

545


What are the restrictions applicable while creating views? : SQL Server Architecture

560


What is a system database and what is a user database?

559