2007-02-10 00:38:32 · 5 answers · asked by ajay 1 in Computers & Internet ➔ Programming & Design
Most important difference is that oracle is a multi user,whereas Access is single user DBMS.
Also Oracle's features for distributed transactions, materialized views and replication are not available with MS Access. These features enable Oracle to efficiently store data for multinational companies across the globe. Also these features increase scalability of applications based on Oracle.
And it is also more secure.
2007-02-10 00:44:22 · answer #1 · answered by Amit 3 · 1⤊ 0⤋
Oracle's features for distributed transactions, materialized views and replication are not available with MS Access. These features enable Oracle to efficiently store data for multinational companies across the globe. Also these features increase scalability of applications based on Oracle.
Oracle is a Multiuser database,it can support a varity of applications.But MS Acces is perform a sigle applications
One important difference is that
We can't create sequence in Microsoft Access.We craete sequence in Oracle.
Oracle database is more secured than MS-Access. Oracle can handle a database having million records very efficiently, but MS-Access has no such quality like Oracle.
2007-02-10 09:37:27 · answer #2 · answered by shah_ramanuj 2 · 0⤊ 0⤋
It's like the difference between a kite and Stealth Bomber. There's really no comparison.
2007-02-10 10:42:24 · answer #3 · answered by Dave 5 · 0⤊ 0⤋
ms-access is handel only limited data base.
oracle is handeled huge number of data base.
oracle is u made client validations on db to retrive exact information like pl/sql,triggers,,,,,
oracle is supported oodbms(object oriented database management system)
2007-02-10 09:21:51 · answer #4 · answered by kikku 1 · 0⤊ 0⤋
ms access is a relationship-based DBMS, oracle is object-oriented
2007-02-10 09:01:55 · answer #5 · answered by sushobhan 6 · 0⤊ 0⤋