ALLInterview.com :: Home Page Forum9.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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
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
Question 
wat is the main diff between sql server 2000and sql server 2005
 Question Submitted By :: Shailendra
I also faced this Question!!     Rank Answer Posted By  
 
  Re: wat is the main diff between sql server 2000and sql server 2005
Answer
# 1		 
the version number!
 
Is This Answer Correct ?    0 Yes 0 No
Mr. Obvious
 
  Re: wat is the main diff between sql server 2000and sql server 2005
Answer
# 2		 
In 2005 More features is available
Database Mirroiring
CLR Integration(Common language Runtime ) Integration
Management Studio
SIS Package
mirror backup
DAC(Dedicate Administration Connection)
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 
 
 
  Re: wat is the main diff between sql server 2000and sql server 2005
Answer
# 3		 
ONLINE INDEX CREATION
ONLINE BACKUP (WHICH IS HOT BACKUP IN ORACLE)
 
Is This Answer Correct ?    0 Yes 0 No
Monal
 
 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication? Microsoft4
What do you mean by COLLATION?  4
How to find the date and time of last updated table?  1
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,... ADP1
what is normalization? what is denormalization? Satyam4
What value could be assigned to Varchar Type?  2
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?  1
How to Execute an Operating System Command From Within SQL Server ?  2
What are the types of indexes available with SQL Server?  2
The Difference between 'Count' and 'Count(*)'  8
What are the OS services that the SQL Server installation adds?  1
Can Somebody tell me the difference between Clustered & Non- Clustered Index?? Progressive3
Which TCP/IP port does SQL Server run on?  2
how to find nth highest salary  19
what is the difference between sql query and google query? TCS2
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX1
how to find out the repeated value from table using groupby function?  3
one table has four field id,name,design,salary. i have to find maximum salary .  6
What is the use of DBCC commands?  1
How do SQL server 2000 and XML linked?  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
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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