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 is 1nf in database?
What is the difference between a database and a spreadsheet?
Do we consider null values the same as that of blank space or zero?
Describe the difference between homogeneous and heterogeneous distributed database.
What is user and end user?
How the status of the Rollback segment can be viewed ?
Explain atomicity and aggregation?
Define normalization.
How to drop all foreign keys in database?
What do you understand by proactive, retroactive and simultaneous update?
Why dbms is used?
What is the most used database?
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)