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
Explain the difference between primary and foreign key?
What is a distributed database system?
What is the best way to determine whether firebird server is running?
Explain snapshot replication.
When is functional dependency said to be the fully functional dependency?
What are notification services?
What is 'cross join'? Or what is cartesian product?
Explain the functionality of dml compiler.
What are the applications of database?
Why is databases important in healthcare?
What is instance in dbms?
What are the 4 main objects of a database?
What is a clause in terms of sql?
What is join? Mention its types.
What is the maximum size of an access database?