what are the differences you find when working with oracle
91 and sql server 2005?
Answer Posted / 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 View All Answers
What are the two types of data independence?
What is record in a database?
How do I create a database?
What are the package used in DBMS ?
What is artificial key?
Why are databases so important?
What is the use of database management system?
What are the basic functions of a database?
Why do we need foreign key?
What is the best database to use?
What is n tier architecture in dbms?
What are the types of database management system?
What is the rdbms concept in sql?
How do you set up a database?
What is dbms_output put_line?