Anonymous

What Is The Main Difference Between Oracle And Sql Server?

4

4 Answers

Anonymous Profile
Anonymous answered
SQL SERVER:
SQL SERVER cheap than ORACLE Servers
SQL Server is simple and easy to install, use and manage
SQL Server supports only windows based platforms(Windows xp, Windows 9x, Server etc)
In Sql server its very complicated to configure Rollback properties.
It has  limitations in Materialized views

Oracle:
Its a platform independent
It has automatic rollback segments.
Its well in Indexing than SQL SERVER
its well in Materialized views than SQL SERVER
it supports recovery options when data has corrupted.
Anonymous Profile
Anonymous answered
Features of oracle:
*Client/Server Architecture.
*Large database and Space Management.
John bmn Profile
John bmn answered

Both database systems perform well but have distinct differences in the way it is operated. Oracle has PL/SQL with packages containing functions & procedures (you can check this useful product - https://www.devart.com/dbforge/oracle/studio/) while MS-SQL only has stored procedures and T-SQL. PL/SQL will stop execution on an unhandled exception while T-SQL has block transactions that move along in a production line. Oracle has tablespaces inside the database on the host while MS-SQL has databases inside the server on the host. Oracle’s rollback segment, redo & archive logs enable it to be controlled more discreetly. But letting this get away easily gets you in a mess.

Anonymous Profile
Anonymous answered
Oracle is a language or tool which uses a database product known as SQL and Sql server is used to connect the Oracle with the database by using Sql query language.

Answer Question

Anonymous