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
Is access a database?
Explain why an information gap exists in most organizations.
what are the different kinds of indexing?
What is a data source (ds)?
What is variable dbms?
What do you understand by clause in sql?
What is the purpose of normalization in dbms?
What are the three levels of data abstraction?
What are stored procedures in a database?
List few disadvantages of file processing system.
What are the basic functions of a database?
Why are recursive relationships are bad? How do you resolve them?
What is db dialect?
Why not phenix, the zelinka/otwinoski libraries, etc?
What are the different types of database?