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 |
Is dynamodb a document database?
How can you perform pattern matching in sql?
Explain primary key and composite key.
Define and explain about progress?
What is the use of drop command?
How do you create a simple database?
How a Store Procedure called with a cursor out parameter.?
Explain atomicity and aggregation?
What is Log Switch ?
Which database is faster?
Does netlib support windows 95?
What is cursor and where do you use them?
Oracle (3253)
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)