what are the differences you find when working with oracle
91 and sql server 2005?



what are the differences you find when working with oracle 91 and sql server 2005?..

Answer / daid kumar

There are so many Difference in oracle 9i and Sql Server2005
some example are as follows:
in Oracle In sqlserver2005
----------------------- --------------------------
1.Schema Database
2.Block Pages
3.Segment N/A
4.Clusters N/A
5.Index(Type) Only One Type is Present
6.Materialized Views N/A
7.Operators N/A
8.Packages N/A
9.Hierarchical Operators N/A
10. In case of partition table in oracle we have Three
option and easely implemented but in Sqlserver It is complx
work Etc.........................

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Database Management Interview Questions

Is dynamodb a document database?

1 Answers  


How can you perform pattern matching in sql?

1 Answers  


Explain primary key and composite key.

1 Answers  


Define and explain about progress?

1 Answers  


What is the use of drop command?

1 Answers  


How do you create a simple database?

1 Answers  


How a Store Procedure called with a cursor out parameter.?

1 Answers   MCN Solutions,


Explain atomicity and aggregation?

1 Answers  


What is Log Switch ?

2 Answers  


Which database is faster?

1 Answers  


Does netlib support windows 95?

1 Answers  


What is cursor and where do you use them?

2 Answers   eBay,


Categories