ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Difference between sql server 2000 and sql server 2005?
 Question Submitted By :: Sam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Difference between sql server 2000 and sql server 2005?
Answer
# 1		 
XML services is provided in 2005 not in 2000
 
Is This Answer Correct ?    9 Yes 2 No
Nishant
 
  Re: Difference between sql server 2000 and sql server 2005?
Answer
# 2		 
1. In SQL Server 2000 the Query Analyzer and Enterprise 
Manager are seperate,whereas in SQL Server 2005 both were 
combined as Management Studio. 

2. In Sql 2005,the new datatype XML is used,whereas in Sql 
2000 there is no such datatype 

3. In Sql server2000 we can create 65,535 databases,whereas 
in Sql server2005 2(pow(20))-1 databases can be created.
 
Is This Answer Correct ?    4 Yes 0 No
Amit Singh
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the basic difference between clustered and a non-clustered index?  2
Anyone please explain me the concept of Serialization?  2
Can you give an example of Stored Procedure?  2
How to find the last update record in SQL Server?  1
How to Debug a Stored Procedure? Allianz3
How to create logins using windows Authentication mode?  1
Difference between Function and Stored Procedure? C1-India3
What is a stored procedure?  3
How can you get @@error and @@rowcount at the same time?  4
Which stored procedure will you be running to add a linked server?  1
what is the importence of the trigger in sqlserver2000? ATI1
what is index seek and index scan?  2
Alternative way to DetDate() function?  2
What are the types of model in sql server and explain TCS1
What is database replicaion? What are the different types of replication you can set up in SQL Server?  2
i want table name basis on column name.  2
Can anybody explain me cold backup and hot backup? TCS2
how to know Who Is Blocking Your SQL Server?  2
What value could be assigned to Varchar Type?  2
when we use function instead of procedure? plz tell me the situation with ex?  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com