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

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

Question Posted / guest

1 Answers
4160 Views
Choice Solutions, I also Faced
E-Mail Answers

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

Who introduced dbms?

0 Answers

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

0 Answers

How big is a big database?

0 Answers

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

1 Answers eBay, Google,

How to improve query performance using index hunting?

0 Answers

What is user and end user?

0 Answers

What are the partitions types available in Oracle10g. How it will do? Simple example?

1 Answers Tech Mahindra,

What is a relation in dbms?