Answer Posted / kani
1.Oracle is multi-user where MS-Access is not.
2.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.
3.We can't create sequence in Microsoft Access.We create
sequence in Oracle.
4.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.
5.oracle is client server technology based while Ms-Access
is not.
6.Oracle follow 11 rule of E.F CODD and access follow 7
rule, oracle give better query performance in comparison to
access, oracle perform high security feature like system
manager, oracle can store unlimited data in access limit.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is ms access and its features?
What are the basic features of ms access?
Is microsoft access being discontinued?
Is there a substitute for microsoft access?
Is there a version of microsoft access for mac?
How are queries run in ms access? List different ways.
Why do you link tables in access?
How would you remodel an existing access database?
How do I update access 2013?
How do you create a database in access?
What is access good for?
What format should my database be saved in to allow different versions of Microsoft Access to open the database?
How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?
What is the difference between form and report in ms access?
Is the popularity of microsoft office still being protected by microsoft access?