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 is the purpose of sql?
Define database lock and its types.
What is database write application of database?
What database does facebook use?
Explain about cursors?
Explain a tp monitor?
What are the benefits of modeling?
What is rdbms with diagram?
What is the difference between horizontal and vertical partitioning?
Explain Relational Algebra in RDBMS
How can I join two tables in database?
What is database normalization? Explain types of it.
Define object-oriented model.
What is difference between database and file?
does pl/sql support “overloading”? Explain