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 |
What are vdl and sdl?
How do you create a blank database?
What do you understand by correlated subqueries in dbms?
How to use events with zebedee, ssh or stunnel?
What do you mean by extension and intension?
Define dbms.
What is a checkpoint in dbms?
What do you mean by transparent dbms?
What's the difference between file and database? Can files qualify as a database?
What is building blocks of client/server?
How do I create a database?
What are the features of dbms?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)